Re: $$Excel-Macros$$ Please help on the data validation

2012-05-29 Thread Naresh V
Smitha, Using developer tab Insert Combo box from Activex controls. Then right click on the combo box, select properties. Now write the source opposit to "Listfillrange". It works Thanks, Naresh V On Tue, May 29, 2012 at 10:04 AM, Bé Trần Văn wrote: > > > 2012/5/29 Mangesh Dayne

Re: $$Excel-Macros$$ Please help on the data validation

2012-05-29 Thread Mangesh Dayne
Check mails of this group. It has been already answered some days before. ManGesh On Tue, May 29, 2012 at 1:36 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 >

$$Excel-Macros$$ Please help on the data validation

2012-05-29 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