DropDown

[Geoff]

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



"Geoff" <[email protected]> wrote in message
news:[email protected]...
> 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]

sorry, missed the "d"

ComboBox1.Enabled = False

Mangesh




"Mangesh Yadav" <[email protected]> wrote in message
news:[email protected]...
> ComboBox1.Enable = False
>
> Mangesh
>
>
>
> "Geoff" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>

[Geoff]

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

[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




"Geoff" <[email protected]> wrote in message
news:[email protected]...
> 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
> >
> >