Drop Down List Autofill
 

Is it possible to autofill from a drop down list?
Thanks in advance.
Rita

If you created the dropdown list through Data Validation, it doesn't
support autocomplete (if that's what you mean by autofill).

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html

Rita wrote:
Is it possible to autofill from a drop down list?
Thanks in advance.
Rita


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi,

See 'this' (http://puremis.net/excel/code/041.shtml)


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=398376