autofilling a cell as the user types

  • Thread starter Thread starter MJKelly
  • Start date Start date
M

MJKelly

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
 
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.
 
Back
Top