DropDown
 

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

DropDown
 

ComboBox1.Enable = False

Mangesh



"Geoff" wrote in message
...
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

DropDown
 

sorry, missed the "d"

ComboBox1.Enabled = False

Mangesh




"Mangesh Yadav" wrote in message
...
ComboBox1.Enable = False

Mangesh



"Geoff" wrote in message
...
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

DropDown
 

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

"Geoff" wrote:

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

DropDown
 

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




"Geoff" wrote in message
...
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

"Geoff" wrote:

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