$$Excel-Macros$$ Drop down list

2012-05-21 Thread Smitha S R
Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils

$$Excel-Macros$$ Drop down list

2010-09-23 Thread Kal xcel
Dear expert, I am facing a problem to create dependent dropdown list. Please check the attached file & help. Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr

$$Excel-Macros$$ drop down list

2009-06-05 Thread Harish
Can we apply following feature in a cell in Excel ?: "Typing in a letter in cell should pick up the dropdown item (from down list ) that matches the letter" let me consider an example to explain this : suppose that drop down list contains following items: 1) America 2) India 3) Sri Lanka 4) Ital

Re: $$Excel-Macros$$ Drop down list

2012-05-21 Thread Anil Gawli
File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R wrote: > Hi, > > I have a drop down list which is created using menu 'data validation'. > > Is it possible to get the items in the first line in the drop down while > start entering the letters of the items. > Eg: Item Pen, pencils,

Re: $$Excel-Macros$$ Drop down list

2012-05-21 Thread Smitha S R
Hi, PFA the book with dropdown list prepared using data validation. Suggest whether it is possible in this also. (s it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I sta

Re: $$Excel-Macros$$ Drop down list

2012-05-21 Thread Anil Gawli
with data validation i don't think so, i have prepared in combo box control. Is it Ok? On Mon, May 21, 2012 at 3:53 PM, Smitha S R wrote: > Hi, > > PFA the book with dropdown list prepared using data validation. > Suggest whether it is possible in this also. > > > (s it possible to get the ite

Re: $$Excel-Macros$$ Drop down list

2012-05-21 Thread Anil Gawli
your attached file is corrupted and cannot be opned? Regards Gawli Anil On Tue, May 22, 2012 at 12:20 AM, Bé Trần Văn wrote: > > > 2012/5/21 Anil Gawli > >> with data validation i don't think so, i have prepared in combo box >> control. >> Is it Ok? >> >> >> >> On Mon, May 21, 2012 at 3:53 P

Re: $$Excel-Macros$$ Drop down list

2012-05-25 Thread Smitha S R
Is this possible in dropdown list as you have prepared using combo box? On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote: > your attached file is corrupted and cannot be opned? > Regards > Gawli Anil > > On Tue, May 22, 2012 at 12:20 AM, Bé Trần Văn > wrote: > >> >> >> 2012/5/21 Anil Gawli

Re: $$Excel-Macros$$ Drop down list

2012-05-29 Thread Smitha S R
Hi anil, How you placed the combo box in Excel? On Fri, May 25, 2012 at 1:27 PM, Smitha S R wrote: > Is this possible in dropdown list as you have prepared using combo box? > > > On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote: > >> your attached file is corrupted and cannot be opned? >>

Re: $$Excel-Macros$$ Drop down list

2012-05-29 Thread Anil Gawli
Goto file option and select customize ribbon and click on choose commands from. Then select All tabs and transfer Develper tab to customize ribbon. Then goto insert combo box Regards, Gawli Anil On Tue, May 29, 2012 at 1:41 PM, Smitha S R wrote: > Hi anil, > > How you placed the combo box in E

Re: $$Excel-Macros$$ Drop down list

2012-05-29 Thread Bé Trần Văn
2012/5/29 Anil Gawli > Goto file option and select customize ribbon and click on choose > commands from. > Then select All tabs and transfer Develper tab to customize ribbon. > Then goto insert combo box > Regards, > Gawli Anil > > > On Tue, May 29, 2012 at 1:41 PM, Smitha S R wrote: > >> Hi a

Re: $$Excel-Macros$$ Drop down list

2010-09-24 Thread ALAM
Hi! FIND OUT DRPODOWN LINS AFTAB On Thu, Sep 23, 2010 at 3:08 PM, Kal xcel wrote: > Dear expert, > > I am facing a problem to create dependent dropdown list. > > Please check the attached file & help. > > Thanks in advance > > Kalyan > > -- > > --

Re: $$Excel-Macros$$ Drop down list

2010-09-24 Thread NOORAIN ANSARI
Dear Kalyan, Please see attachment... Thanks, Noorain Ansari On Thu, Sep 23, 2010 at 3:08 PM, Kal xcel wrote: > Dear expert, > > I am facing a problem to create dependent dropdown list. > > Please check the attached file & help. > > Thanks in advance > > Kalyan > > -- > > -