Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop the _Change event? Is there EnableEvents for Forms?
I would like to be able to temporarily disable one of the _Change events in
my form because I don't want it to fire during, for example, the initialize sub. I've tried several things including using the .enabled=false, and ..locked=false, and even Application.EnableEvents = False, ...but the _Change event still fired. Here is the specific sub I want to temporarily disable. It's for a textbox called CurrentPBox that calls a very involved Draw routine. Private Sub CurrentPBox_click() If IsNumeric(CurrentPBox) And CurrentPBox <= CurrentPSpin.Max _ And CurrentPBox = CurrentPSpin.Min Then pCurrentP = CurrentPBox 'if its a valid value, store the value & spin CurrentPSpin = CurrentPBox DrawPetal pCurrentP, p, m, s, pCor pBox = pCurrentP Else CurrentPBox = pCurrentP 'if its invalid, replace it with what had been there End If End Sub Thanks! -Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with sub..._Change | Excel Programming | |||
enableevents in event codes | Excel Programming | |||
Why _Change(ByVal Target As Range) | Excel Programming | |||
Application.EnableEvents = true, but no event fires | Excel Programming |