Prev: Function Last Row()
Next: Cannot seem to Cancel EXCEL App Right Click Event using C#
From: Michelle on 27 Oct 2009 08:07
On my user form, I want Control1 to effect the value of Control2, but when
it does, I don't want the change event for Control2 to be triggered.

Enable events doesn't work

Can I temporarily switch off the change event, then change the control then
switch it back on?

thanks

M

From: Jan Karel Pieterse on 27 Oct 2009 08:17
Hi Michelle,

> On my user form, I want Control1 to effect the value of Control2, but when
> it does, I don't want the change event for Control2 to be triggered.
>
> Enable events doesn't work
>
> Can I temporarily switch off the change event, then change the control then
> switch it back on?

See:

http://www.jkp-ads.com/Articles/NoEvents00.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

From: Patrick Molloy on 27 Oct 2009 08:26
Applicaton.EnableEvents = FALSE

should work

"Michelle" wrote:

> On my user form, I want Control1 to effect the value of Control2, but when
> it does, I don't want the change event for Control2 to be triggered.
>
> Enable events doesn't work
>
> Can I temporarily switch off the change event, then change the control then
> switch it back on?
>
> thanks
>
> M
>
From: Jan Karel Pieterse on 27 Oct 2009 08:57
Hi Patrick,

> Applicaton.EnableEvents = FALSE
>
> should work

Not for userform control events.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

From: Patrick Molloy on 27 Oct 2009 09:10
apologies - I misread the question. you could create a 'flag' to exit
control2's event

say bIgnore as boolean

in control1 set thios to TRUE, make the change, then set it back to false
in control2 make the first line
If bIgnore then Exit Sub





"Patrick Molloy" wrote:

> Applicaton.EnableEvents = FALSE
>
> should work
>
> "Michelle" wrote:
>
> > On my user form, I want Control1 to effect the value of Control2, but when
> > it does, I don't want the change event for Control2 to be triggered.
> >
> > Enable events doesn't work
> >
> > Can I temporarily switch off the change event, then change the control then
> > switch it back on?
> >
> > thanks
> >
> > M
> >
 |  Next  |  Last
Pages: 1 2
Prev: Function Last Row()
Next: Cannot seem to Cancel EXCEL App Right Click Event using C#