Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rita
 
Posts: n/a
Default Drop Down List Autofill

Is it possible to autofill from a drop down list?
Thanks in advance.
Rita
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

  #3   Report Post  
Krishnakumar
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM
Using symbols for drop down list boxes? Sumeet Benawra Excel Worksheet Functions 0 April 19th 05 11:41 AM
Pull unique names for drop down list [email protected] Excel Discussion (Misc queries) 3 February 1st 05 10:23 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 11:42 AM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"