How do I edit sheet while a macro is running?

L

limpos

Joined
Oct 2, 2005
Messages
1
Reaction score
0
Hi,

I am making a simulation application, where I'd like to make changes in the worksheet and change controls (drag bars etc) while a macro is running. How do I do this?

I tried using the Ontime command: I let the maro run only a short time and then finish. Then the simulation was resumed by using OnTime that started the macro up again after 1 s. This worked well to make it possible to edit the worksheet while running, but it made the updating very slow (once every second). So, an OnTime command that works for shorter than 1 s would solve the problem....

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnTimer - The macro 'macro name' cannot be found. 2
Running Ontime's procedure while another function is running? 1
Scheduling Macro run 1
Running a Macro periodically between Time A and Time B 7
Force macro to run on a specific worksheet 2
Commandbar will not refresh while macro is running 3
Running a macro every half hour 4
Two Questions - Need help 3

Back
Top