combobox change event is running when enable events is false

I am writing some VBA that changes the value in a control toolbox combobox,
but I don't want it to run the code assigned to changing the combobox ( it
clears it runs some other code and then changes it to a different value). I
therefore disabled enableevents, but it is still doing so. I have even put a
messagebox at the start of the combobox change event code to display the
enableevents status, and getting False back!

Is there anyway to avoid this, as surely the purpose of being able to
disable events is that this shouldn't happen.


I am using excel 2000 if that makes any difference.

Many thanks

Hi Tysop,

Try using a public boolean variable selectively to disable the ComboBox
code.

At the top of a standard module:

Option Explicit

Public blDisable As Boolean

Then, in the sheet module:

'=============>>
Private Sub ComboBox1_Change()
If blDisable Then Exit Sub
'Your code
End Sub
'<<=============

When you need to disable the ComboBox1_Change code, assign a value of True
to the variable.


---
Regards,
Norman


"tysop" <tysop@discussions.microsoft.com> wrote in message
news:F29A57C9-7EBD-42F3-8938-00CB21E8870F@microsoft.com...
>I am writing some VBA that changes the value in a control toolbox combobox,
> but I don't want it to run the code assigned to changing the combobox ( it
> clears it runs some other code and then changes it to a different value).
> I
> therefore disabled enableevents, but it is still doing so. I have even
> put a
> messagebox at the start of the combobox change event code to display the
> enableevents status, and getting False back!
>
> Is there anyway to avoid this, as surely the purpose of being able to
> disable events is that this shouldn't happen.
>
>
> I am using excel 2000 if that makes any difference.
>
> Many thanks
>

I actually had just tried that and it works, but it's just annoying that I
now have to change a boolean and dissable events- I'll probably create a sub
that disables both and call that when i need to.

Many thanks

Tysop

"Norman Jones" wrote:

> Hi Tysop,
>
> Try using a public boolean variable selectively to disable the ComboBox
> code.
>
> At the top of a standard module:
>
> Option Explicit
>
> Public blDisable As Boolean
>
> Then, in the sheet module:
>
> '=============>>
> Private Sub ComboBox1_Change()
> If blDisable Then Exit Sub
> 'Your code
> End Sub
> '<<=============
>
> When you need to disable the ComboBox1_Change code, assign a value of True
> to the variable.
>
>
> ---
> Regards,
> Norman
>
>
> "tysop" <tysop@discussions.microsoft.com> wrote in message
> news:F29A57C9-7EBD-42F3-8938-00CB21E8870F@microsoft.com...
> >I am writing some VBA that changes the value in a control toolbox combobox,
> > but I don't want it to run the code assigned to changing the combobox ( it
> > clears it runs some other code and then changes it to a different value).
> > I
> > therefore disabled enableevents, but it is still doing so. I have even
> > put a
> > messagebox at the start of the combobox change event code to display the
> > enableevents status, and getting False back!
> >
> > Is there anyway to avoid this, as surely the purpose of being able to
> > disable events is that this shouldn't happen.
> >
> >
> > I am using excel 2000 if that makes any difference.
> >
> > Many thanks
> >
>
>
>

Just for clarification, enableevents is part of the Excel Object model.
MSForms controls are part of the MSForms object model. These controls are
not affected by the EnableEvents setting.

--
Regards,
Tom Ogilvy

"tysop" <tysop@discussions.microsoft.com> wrote in message
news:5B5D0B4C-7CBB-4739-A595-269AFD9607D3@microsoft.com...
> I actually had just tried that and it works, but it's just annoying that I
> now have to change a boolean and dissable events- I'll probably create a
sub
> that disables both and call that when i need to.
>
> Many thanks
>
> Tysop
>
> "Norman Jones" wrote:
>
> > Hi Tysop,
> >
> > Try using a public boolean variable selectively to disable the ComboBox
> > code.
> >
> > At the top of a standard module:
> >
> > Option Explicit
> >
> > Public blDisable As Boolean
> >
> > Then, in the sheet module:
> >
> > '=============>>
> > Private Sub ComboBox1_Change()
> > If blDisable Then Exit Sub
> > 'Your code
> > End Sub
> > '<<=============
> >
> > When you need to disable the ComboBox1_Change code, assign a value of
True
> > to the variable.
> >
> >
> > ---
> > Regards,
> > Norman
> >
> >
> > "tysop" <tysop@discussions.microsoft.com> wrote in message
> > news:F29A57C9-7EBD-42F3-8938-00CB21E8870F@microsoft.com...
> > >I am writing some VBA that changes the value in a control toolbox
combobox,
> > > but I don't want it to run the code assigned to changing the combobox
( it
> > > clears it runs some other code and then changes it to a different
value).
> > > I
> > > therefore disabled enableevents, but it is still doing so. I have
even
> > > put a
> > > messagebox at the start of the combobox change event code to display
the
> > > enableevents status, and getting False back!
> > >
> > > Is there anyway to avoid this, as surely the purpose of being able to
> > > disable events is that this shouldn't happen.
> > >
> > >
> > > I am using excel 2000 if that makes any difference.
> > >
> > > Many thanks
> > >
> >
> >
> >