| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation
I have a huge list in Data Validation mostly the names.
When the cell is selected drop down menu will appear, but what i like to know is when a type a particular letter it should go to the names starting with that corresponding letter ( as we select the file by typing the starting letter). Help will be appreciated. Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data validation
This isn't supported in Data|Validation.
Naveen wrote: I have a huge list in Data Validation mostly the names. When the cell is selected drop down menu will appear, but what i like to know is when a type a particular letter it should go to the names starting with that corresponding letter ( as we select the file by typing the starting letter). Help will be appreciated. Thanks in advance -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data validation
can someone help me to have the code written for this
"Dave Peterson" wrote: This isn't supported in Data|Validation. Naveen wrote: I have a huge list in Data Validation mostly the names. When the cell is selected drop down menu will appear, but what i like to know is when a type a particular letter it should go to the names starting with that corresponding letter ( as we select the file by typing the starting letter). Help will be appreciated. Thanks in advance -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data validation
Maybe it's time to replace the data|validation cells with comboboxes from the
Control toolbox toolbar. If you rightclick on one of those comboboxes (while in design mode), you can choose properties. You can choose .Style to be fmStyleDropDownList and you can choose .MatchEntry to be fmMatchEntryFirstLetter Naveen wrote: can someone help me to have the code written for this "Dave Peterson" wrote: This isn't supported in Data|Validation. Naveen wrote: I have a huge list in Data Validation mostly the names. When the cell is selected drop down menu will appear, but what i like to know is when a type a particular letter it should go to the names starting with that corresponding letter ( as we select the file by typing the starting letter). Help will be appreciated. Thanks in advance -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| existing data in case of data validation | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
