DropDown

[Guest]

Hi
I need to prevent the DropButtonClick event under certain circumstances
existing elsewhere on a userform without using the other controls exit events
with Cancel = True.

I do not want to disable or lock the combobox either.

Syntax like ComboBox1.DropDown = False doesn't have any effect.

Is there a way?

T.I.A.

Geoff

 

[Mangesh Yadav]

ComboBox1.Enable = False

Mangesh

 

[Mangesh Yadav]

sorry, missed the "d"

ComboBox1.Enabled = False

Mangesh

 

[Guest]

Hi
No, as I said in my post I do not want to disable the cbobox. If it is
disabled or locked then a click event on the cbobox cannot be recognised.

Geoff

 

[Mangesh Yadav]

Then try setting a flag which changes to TRUE or FALSE as per your
condition, and then in the click event check the status of the flag.

Mangesh