Prev: Function Last Row()
Next: Cannot seem to Cancel EXCEL App Right Click Event using C#
From: Dave Peterson on 27 Oct 2009 09:35
Check your other thread.

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

--

Dave Peterson
From: Michelle on 27 Oct 2009 10:42
Thanks - great

M


"Jan Karel Pieterse" <jkpieterse(a)netscape.net> wrote in message
news:VA.000005f8.060484ec(a)netscape.net...
> 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
>

First  |  Prev  | 
Pages: 1 2
Prev: Function Last Row()
Next: Cannot seem to Cancel EXCEL App Right Click Event using C#