Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
Dave
Assuming a Data Validation List drop-down. To allow users to enter a not-on-the-list item in the cell disable the "show error alert after user enters invalid data". The new item will not be added to the list however. To do this would require VBA code. As far as autocomplete goes...........DV lists cannot autocomplete. You need a combo box for that. See Debra Dalgleish's site for code. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Tue, 05 Dec 2006 18:41:56 GMT, "Dave" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list of a drop down list | Excel Worksheet Functions | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |