Break timer

YvorL

New Member
Joined
Sep 3, 2010
Messages
46
Hi!

I've the following task:
For about 80 people I've to create something that follows:
- who is on break at the moment
- who would like to go
- notify a user if he/she can go to take a break, if the user can't react to this notification it should timeout (disappear)

Unfortunately I have no resources so the only option which is common here and runs shared is office. So I decided to go with excel.
(it'd be easy if I could use a webpage, but that's not possible)

I managed to do almost everything, but the notification is very tricky. I use MessageBoxTimeout (user32.dll).
The only problem at the moment is that this popup window is always on top and there is no way to send back. (this is the nature of this window).
So I need a way to notify the user with some kind of window which has the option for timeout and can send the result (ok/No/timeout) back to the excel macro. But it wont stay as the foremost window. The best option would be that if woluld blink on the taskbar. Or an another window.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,223,714
Messages
6,174,051
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top