Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dude
 
Posts: n/a
Default autocomplete from a drop down list

How can I set up autocomplete from a drop down list?
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

If you use a combo box from the control toolbox, you can set its
autocomplete property to true:
On the control toolbox, click the Design Mode button
Select the combo box
On the control toolbox, click the Properties button
Set the MatchEntry property to: fmMatchEntryComplete

If the dropdown is from data validation, it doesn't support
autocomplete. However, there's a sample file here that provides 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/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'

Dude wrote:
How can I set up autocomplete from a drop down list?



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

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
link to result from drop down list dcruickshank Links and Linking in Excel 1 January 20th 05 11:57 PM
Autocomplete based on a different worksheet. rv Excel Discussion (Misc queries) 3 December 8th 04 05:39 AM
Drop down list Jinxy Excel Discussion (Misc queries) 3 November 29th 04 01:34 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 08:10 PM
Filling drop down box Nick Excel Discussion (Misc queries) 0 November 25th 04 08:49 PM


All times are GMT +1. The time now is 10:30 PM.

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

About Us

"It's about Microsoft Excel"