MrExcel.com - Your One Stop for Excel Tips & Solutions

MSG Box

Posted by barry on November 17, 2001 3:38 AM

is it possible to have a msg box on a time limit so that it opens for say 5 seconds then closes automatically

Posted by orangoetang on November 17, 2001 10:54 AM

I'm not sure but I think you can get what you want by creating a userform. you can make it visible by using "userform1.show" or hide it by
"userform1.hide". Combine this with a timer or time-function and then you have an alternative for the msgbox. I think the msgbox waits until a button is pushed.