Hi Dave

To allow other entries, go to the Error tab on the DV dialogue and
untick the box.

You can go to the first T etc., if you break your list up, with a single
cell at the beginning of each change in the alphabet, with A, B C etc.
then type T in the DV cell before pressing the dropdown, it will start
at T.

--
Regards

Roger Govier


"Dave" wrote in message
...
First of all I have created a list of clients, from that list of
clients the user can view, and select in a cell using the drop down
tool. This drop down tool does not allow any other entries except for
the ones from the list is there away I can put in another entry
without the error popping up? Another question is that when the user
presses t for example, it would be good if the drop down list goes to
the ts strait away without having to go through the list.