cell formatting?? and making it so that it will move to the first option on a listing

  • Thread starter Thread starter ratt
  • Start date Start date
R

ratt

I am using data validation on a cell and using a list of option ( part
names etc...) and wish to know if there is an option that a user can
start to type in a name of the part and the cell would automatically go
to the first possible option..i.e the use types in the letter p and the
part processor will show up...or power supply when the next letter s
type)

tks ahead of time if a resolution or viable option is available


ratt out!!!! :)
 
Data Validation dropdown lists don't support autocomplete. 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
 

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

pre-fill cell by typing first few letters of a list 1
How do I only make a cell available if an option from a differentvalidated cell is selected in Excel 2
Data From One Worksheet To Be Used In A Cell In A Different Worksheet 5
Formatted cell column in drop down list 1
Can I format one cell so that it affects another cell? 4
FORMULA WITH A CELL THAT HAS A DATA VALIDATION LIST IN IT 2
Pick List + Alphabetical Skip To or Auto Complete 2
a data validation list that contains a list of named ranges - not alist from a named range 1

Back
Top