Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
From memory I seem to recall that if you use a list to validate the data in a dropdown box, as the user types, the entry automatically fills, so the user can press tab when the correct data is visible. How can I do this in a normal cell? To clarify, I have a named range which I use as a list to validate the input of a cell. This named range consists of staff names. As the user types, I want the name to start to populate in the cell, as this will be quicker than selecting the name from a long list in the dropdown list of the validated cell. Can I have the cell autofill/populate like this? Hope you can help... Matt |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you create the dropdown list and define (name) the range as you describe
in the past it will work. The user can just ignore the dropdown arrow and start typing in the cell. Once the user starts typing in the cell it will autopopulate. The catch is that the user typing their name in a cell has to achieve a unique combination before the correct name will appear. For example if you have and Employee name Steve and one Named Stewart, Stewart will have to type in STEW before the correct name would autopopulate. "MJKelly" wrote: Hi, From memory I seem to recall that if you use a list to validate the data in a dropdown box, as the user types, the entry automatically fills, so the user can press tab when the correct data is visible. How can I do this in a normal cell? To clarify, I have a named range which I use as a list to validate the input of a cell. This named range consists of staff names. As the user types, I want the name to start to populate in the cell, as this will be quicker than selecting the name from a long list in the dropdown list of the validated cell. Can I have the cell autofill/populate like this? Hope you can help... Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reset a User Defined Types Values | Excel Programming | |||
User Defined Types and Overloaded Operators | Excel Programming | |||
Checking user defined types for Nothing | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming |