Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get looping VBA code to respond to events on worksheet
Hello,
I have some code of the form do while not g_Paused bunch of calls ... loop where I'd like the variable g_Paused to be toggled by a button on the worksheet. The only way I can seem to get the code to respond to the button click is to use do while not g_Paused bunch of calls ... ThisWorkbook.Worksheets("Name").Activate DoEvents loop But this is pretty slow and causes the sheet to flicker...is there a better method? PS I'm using buttons from the Control Toolbox Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting .NET form to respond to Excel window events | Excel Programming | |||
Force event code to NOT respond | Excel Programming | |||
Worksheet events and a little bit extra code | Excel Programming | |||
worksheet tabs do not respond to grouping | Excel Discussion (Misc queries) | |||
excel.application.run macro1 -- added code to respond "yes" to a inputbox | Excel Programming |