M
monkeyboy
Hello,
I'm writing a small simulator that continuously runs a loop walking
out in time, the loop is in a module unassociated with a sheet. I'd
like it to respond to button clicks on the display sheet to start and
stop. The only way I can seem to accoplish this is to put the
following within the main simulation loop
'grab any events happening outside the code on the FLOWSHEET worksheet
ThisWorkbook.Worksheets("FLOWSHEET").Activate
DoEvents
I'm writing a small simulator that continuously runs a loop walking
out in time, the loop is in a module unassociated with a sheet. I'd
like it to respond to button clicks on the display sheet to start and
stop. The only way I can seem to accoplish this is to put the
following within the main simulation loop
'grab any events happening outside the code on the FLOWSHEET worksheet
ThisWorkbook.Worksheets("FLOWSHEET").Activate
DoEvents