Counter for Msgbox

[BenNV]

I have a message box output when I click a button. I want the message box to act as a counter say, it counts 3, 2, 1 then the msg box automatically goes. So, it is acting as a countdown. Is this possible?

[Ivan F Moala]

On 2002-04-15 03:18, BenNV wrote:
I have a message box output when I click a button. I want the message box to act as a counter say, it counts 3, 2, 1 then the msg box automatically goes. So, it is acting as a countdown. Is this possible?

Do you mean a timed msgbox where by it displays for 3 secs then cancels and takes a default setting ??

[BenNV]

Thanks for the reply.

Yes, I just want a 3 second timer and after the 3 secs, the msg box goes and goes back to the workbook without any changes. Like a wait 3 seconds command.

[daleyman]

no, you cannot change the msgbox text once it is shown, or cancel the dialog programmatically.

your best bet is to create a small userform with just a text label on it, then use this form to do what you want.

[glockster]

I'm not sure if this would work with a message box. But if you could use a "userform" instead, you can use this code in the userform:

Private Sub UserForm_Activate()
Application.Wait Now + TimeValue("00:00:03")
Userform1.Hide
End Sub

[Ivan F Moala]

On 2002-04-15 06:18, daleyman wrote:
no, you cannot change the msgbox text once it is shown, or cancel the dialog programmatically.

your best bet is to create a small userform with just a text label on it, then use this form to do what you want.

Yes you can cancell a msgbox programatically
You have to use the Address of functon and
the system Timer.