G
Guest
Hi
I would like to prevent the list showing in a combobox if a condition is not
met in another control elsewhere on a userform.
It is not possible to use the other control's Exit event and Cancel = True
and I cannot disable or lock the combobox as it's DropButtonClick event would
not be fired.
If
ComboBox1.DropDown can reveal the list then:
ComboBox1.DropDown = False has no effect.
What should the syntax be to prevent DropDown? Appreciate any ideas.
T.I.A.
Geoff
I would like to prevent the list showing in a combobox if a condition is not
met in another control elsewhere on a userform.
It is not possible to use the other control's Exit event and Cancel = True
and I cannot disable or lock the combobox as it's DropButtonClick event would
not be fired.
If
ComboBox1.DropDown can reveal the list then:
ComboBox1.DropDown = False has no effect.
What should the syntax be to prevent DropDown? Appreciate any ideas.
T.I.A.
Geoff