autocomplete from a drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autocomplete for Drop-Down? 1
Drop Down list for entering data 1
make my own list like formula autocomplete 3
Drop Down Lists 6
Automatic Drop-down of Dropdown list 3
validation list 1
Filtered drop down list 2
Shortcut to make a drop-down LOV show during data entry? 1

Back
Top