predicitve text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a list of 500 customers in one sheet and I would like to use a
dropdown menu on a seperate sheet is it possible for excel to use perdicitve
text so when I start typing a customers name it lists those customers that
begin with the leters I have typed?
Thanks
 
Ron

A file that can be downloaded from Debra Dalgleish's site uses a Combobox.

Can be found at

http://www.contextures.on.ca/excelfiles.html#DataVal

Scroll down until you find......

Data Validation Combobox-- Double-click on a cell that contains a data
validation list, and a combobox appears -- font size can be set, more than 8
rows displayed, and autocomplete can be enabled. Macros must be enabled.
DataValCombobox.xls 32 kb


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

auto fill or if function 2
Extracting data to another sheet using multiple criteria 1
VBA to automatically cut, paste entire row based on date input and delete row 0
Drop down menu 3
locate to particular in a dropdown list 1
auto fill or auto search from a list or drop-down list??????? 9
drop down list selection 1
Auto fill with custom list 2

Back
Top