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
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