Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop down menus in excel
is it possible when using a drop down menu to have an error message pop up
if you've selected something that has already been used. Example - if you are making seating plans where you want to make sure you don't select the same person twice. |
#2
|
|||
|
|||
There's an example here for preventing duplicate entries with data
validation: http://www.contextures.com/xlDataVal07.html#Unique Or you can hide used items in the dropdown list: http://www.contextures.com/xlDataVal03.html rowing coach wrote: is it possible when using a drop down menu to have an error message pop up if you've selected something that has already been used. Example - if you are making seating plans where you want to make sure you don't select the same person twice. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) |