stumped
Posted by bampson on January 04, 2002 5:04 PM
Is it possible to have a list of people , and if you change one of the names in the list to sick or vacation" have excel give you a drop down menu with another list of people that you could choose from, once you click on your choice that person disappear from the drop down menu ?
any help would be greatly Appreciated..
thanx
bamp
Posted by Damon Ostrander on January 06, 2002 10:46 PM
Hi bampson,
Yes. Just use the worksheet's Change event to trap when you enter "sick" or "vacation" in a range of cells. Create a custom userform with the people dropdown list. Then when that event occurs search the dropdown menu list for that person and delete it. If the dropdown list is linked to a cell range your code would only need to delete it from that range. The problem would be if you wanted to restore that person's name to the list, in which case you would need to create a copy of it someplace else.
I hope this is enough explanation to be of some help.
Damon
