Geoff,
Perhaps disable the Combobox (Enabled=False) while your
condition exists?

"Geoff" wrote:

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