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" <(E-Mail Removed)> wrote in message
news:5B5D0B4C-7CBB-4739-A595-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:F29A57C9-7EBD-42F3-8938-(E-Mail Removed)...
> > >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
> > >
> >
> >
> >
|
Similar Threads
