problem validating list

Joined
May 7, 2009
Messages
2
Reaction score
0
Hi,

I have a named list and I am using it as a listbox (assigned with data->validation->list).

The named list is variable, since it is made with a VBA script.

I have 2 sheets. One with some buttons, and the other with the listbox (and some other stuff).


Now, suppose I have a list A, B, C, D and I select C.
Now C is removed because the user clicks a certain button.

When C is removed, the listbox is updated correctly (so I can only select A,B and D), but when C was selected before it was removed, C is still being selected in the listbox.

How can I make sure this value is not selected (so the listbox is empty) ?

Thanks in advance,
Kind regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top