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