how to break a timed message?

**b1ll** · 03-05-2009, 08:25 AM

Hi I have message boxes which are for information but if no one is looking then I want my program to continue on. This code does that and shows a box with an 'OK' button. Now if someone is looking then I want to recognise a press of the button. I have tried various things like vbOK, vbOnly but no joy - so what's the magic line please?

'shows countdown
For counT = 5 To 1 Step -1
    message.popUp "This message will show for " & counT & " seconds", 1, "Quick Message " & counT
Next

TKIA

**blane245** · 03-05-2009, 09:35 AM

Have you tried using a modeless form? If you create a form and then use userform1.Show vbModeless, the form will display but will not stop the execution of the program.

**b1ll** · 03-05-2009, 10:09 AM

Thanks for the reply but sorry I should have said - I am using Excel '97 so do not think vbModeless is an option - it is not recognised.

**blane245** · 03-05-2009, 10:55 AM

I can't help you further. I never used Excel '97. Maybe you can check in teh ehlp documentation about using modeless windows. It may have been implemented a different way.