A timed MsgBox when a certain checkbox is checked

stickyfeet · Feb 25th 2005

Hi all,

I've been trying to get a Timed MsgBox (eg every 30 mins), but I only want it to appear if a certain checkbox has been checked. Then if the checkbox has been unchecked the timed MsgBox stops.

I've been pulling my hair out, and can't find any examples for this type of VBA.

Can anyone help or point me in the right direction? any help is truly appreciated.

Many thanks

SF

Dave Hawley · Feb 25th 2005

Re: A timed MsgBox when a certain checkbox is checked

Hi SF

See Run a Macro at set times for details on the OnTime Method.

Ivan F Moala · Feb 25th 2005

Re: A timed MsgBox when a certain checkbox is checked

Also have a look here ............

http://www.xcelfiles.com/Excel03.html

stickyfeet · Feb 25th 2005

Re: A timed MsgBox when a certain checkbox is checked

Thanks both. Will have a look.

A timed MsgBox when a certain checkbox is checked

Participate now!

Share