RogerKMiller
asked on
Is it possible to run multiple worksheet macros at the same time on the same worksheet with Excel
I have 12 countdown timers on the same worksheet to be used in front of fryers in our restaurant.
Is it possible to run multiple ones at the same time. Currently each macro is tied to each Start command button and is stopped by it's own Stop command button.
Is it possible to run multiple ones at the same time. Currently each macro is tied to each Start command button and is stopped by it's own Stop command button.
Not that i know. But you could simply run a procedure on Application.OnTime every second, and in this VBA function, you can check if the Start Button have been pressed for a given counter, and decrease it if necessary.
RogerKMiller,
Couple of options...
- Start excel 12 times and have each version run a separate time. (No, I don't think much of that option, either.)
- Not absolutely sure about this, but... Use a single "master" macro, have it sleep for a second, with DoEvents enabled. Have an Event so that a user action is trapped (e.g. selecting a a timer's "Start" cell). The event then updates a hidden cell value changing the status of that timer. A second later the master timer wakes up, reads the hidden cells and updates timers accordingly.
Regards,
Brian.
Couple of options...
- Start excel 12 times and have each version run a separate time. (No, I don't think much of that option, either.)
- Not absolutely sure about this, but... Use a single "master" macro, have it sleep for a second, with DoEvents enabled. Have an Event so that a user action is trapped (e.g. selecting a a timer's "Start" cell). The event then updates a hidden cell value changing the status of that timer. A second later the master timer wakes up, reads the hidden cells and updates timers accordingly.
Regards,
Brian.
Apologies, cdebel, crossing posts.
Regards,
Brian.
Regards,
Brian.
(no prob Redmondb)
Here's an example of what i just talked.
I've just done 2 timers in this version, but you can put as much as you want.
CountDown.xlsm
Here's an example of what i just talked.
I've just done 2 timers in this version, but you can put as much as you want.
CountDown.xlsm
Very nice, cdebel. Shorter and sweeter!
Regards,
Brian.
Regards,
Brian.
ASKER
cdebel:
When opening it, I guess because I have 2003, it says "Can't exit Design Mode because Control 'btnStart1 can not be created. Also I tried to view the code for the buttons but couldn't get anywhere. Looks good if I can understand how it works. Can you perhaps send it in an earlier format?
Thanks,
Roger
When opening it, I guess because I have 2003, it says "Can't exit Design Mode because Control 'btnStart1 can not be created. Also I tried to view the code for the buttons but couldn't get anywhere. Looks good if I can understand how it works. Can you perhaps send it in an earlier format?
Thanks,
Roger
How about this? Its a free download and you can run multiple instances... These are countdown timers.
http://www.downv.com/Windows/download-AleJenJes-Countdown-Timer-10280820.htm
Dave
http://www.downv.com/Windows/download-AleJenJes-Countdown-Timer-10280820.htm
Dave
ASKER
dlmille:
the kitchen one looked like it might work but it wouldn't download. It went thru all the motions but didn't download. I need to make these editable with the name of a food item, like French Fries and then have a countdown timer beneath it or next to it with a start and a stop button.
the kitchen one looked like it might work but it wouldn't download. It went thru all the motions but didn't download. I need to make these editable with the name of a food item, like French Fries and then have a countdown timer beneath it or next to it with a start and a stop button.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Looks great!
Thanks,
Roger
Thanks,
Roger
cdebel,
Small correction..."RogerKMiller " :)
Cheers,
Brian.
Small correction..."RogerKMiller
Cheers,
Brian.
oops :D
works for me. glad you got a solution!
Dave
Dave
ASKER
Thanks,
Roger
Roger