toggle through list using first letter of word

  • Thread starter Thread starter Dave W
  • Start date Start date
D

Dave W

I have several lists that appear as a result of
selections from other list through data validation.

Is there a way to go right to say ..all the words that
begin with "s" by selecting "s" on the keyboard then
toggling thru just the "s's"to make your choose after
activating the proper drop down list. Is there a function
formula or do I need VBA. I get so tired of scolling
thru long lists of data.

Thanks in advance
 
Not sure exactly what you want here.

If you have single letters as part of your Data Validation set you ca
enter a single letter in the cell and then click the down arrow to d
what you want.

You can use a combobox from the Controls Toolbar which automaticall
picks the first item in its ListFillRange which starts with tha
letter.


You do not say what you want to happen when something is selected
 

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

choosing from drop down lists easily 1
Depedent Dropdown and INDIRECT($P$8) with a twist 4
dependent drop down list 1
list in data validation 4
Using Drop Down List or Combo Box 9
Create a drop-down list from a range of cells 2
Width of DV drop down list changes 1
Data Validation 2003, Named Ranges/Formulas 1

Back
Top