Re: $$Excel-Macros$$ combo box or list box help

2012-02-19 Thread Prajakt Pande
Dear Noorain, Thnak for your help On Feb 16, 9:12 pm, NOORAIN ANSARI wrote: > Dear Prajakt, > > Please see attached sheet with explanation. > > On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote: > > > > > > > Dear, > > > Good job, can you tell me how you made this. > > > Regards, > > Prajakt

Re: $$Excel-Macros$$ combo box or list box help

2012-02-17 Thread Sanjib Chatterjee
many many thank you N Ansary for you quick reply regards, Sanjib On Fri, Feb 17, 2012 at 2:02 PM, NOORAIN ANSARI wrote: > Dear Sanjib, > > Please find attachment in 2003 Version. > > On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear N ANSARI,

Re: $$Excel-Macros$$ combo box or list box help

2012-02-17 Thread NOORAIN ANSARI
Dear Sanjib, Please find attachment in 2003 Version. On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear N ANSARI, > > WOULD YOU PLEASE CREATE THE ATTACH FILE IN 2003 FORMAT. . > > THANKING YOU IN ADVANCE. > > SANJIB > > > > On Thu, Feb 16, 2012 at

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread NOORAIN ANSARI
Dear Prajakt, Please see attached sheet with explanation. On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote: > Dear, > > Good job, can you tell me how you made this. > > Regards, > Prajakt Pande > > > On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote: > >> Hi, >> Please chek it >> >> On Thu

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread Prajakt Pande
Dear, Good job, can you tell me how you made this. Regards, Prajakt Pande On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote: > Hi, > Please chek it > > On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> >> Dear Experts, >> >> Please see the attac

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread NOORAIN ANSARI
Process 1 Drag Combobox From Developer-Insert-Form 2 Select Combobox and goto Developer-Properties and Select Areal List and select Cell Link Cell 3 create formula =ADDRESS(2,8+H1)&":"&ADDRESS(100,8+H1) 4 Create Offset Function =OFFSET($H$1,0,$H$1,COUNTA(INDIRECT($B$12)),1),Copy it and Paste i

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread Sanjib Chatterjee
Once again thank you Sir for quick reply. But would you please show me the process. Regards, Sanjib On Thu, Feb 16, 2012 at 4:57 PM, Shaik Waheed wrote: > Hi, > Please chek it > > On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> >> Dear Expe

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread NOORAIN ANSARI
Dear Sanjib. See attached sheet. On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Experts, > > Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo > box or in Text Box. > > Base on the value store in the combo Box or list b

Re: $$Excel-Macros$$ combo box or list box help

2012-02-16 Thread Shaik Waheed
Hi, Please chek it On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Experts, > > Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo > box or in Text Box. > > Base on the value store in the combo Box or list box I like the n