Update Complete Message
 

Hi
Can anyone suggest an option to display a attractive looking message
advising the user that the macro has completed that will stay on the screen
for say 5 seconds and then close?

Thx

Update Complete Message
 

userform1.Show

Application.Wait(Now + TimeValue("0:00:05"))

Unload Userform1

--
Regards,
Tom Ogilvy


"Andym" wrote in message
...
Hi
Can anyone suggest an option to display a attractive looking message
advising the user that the macro has completed that will stay on the
screen
for say 5 seconds and then close?

Thx

Update Complete Message
 

correction - I forgot to use the vbModeless argument


Userform1.show vbModeless
Application.Wait(Now + TimeValue("0:00:10"))
Unload Userform1

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
userform1.Show

Application.Wait(Now + TimeValue("0:00:05"))

Unload Userform1

--
Regards,
Tom Ogilvy


"Andym" wrote in message
...
Hi
Can anyone suggest an option to display a attractive looking message
advising the user that the macro has completed that will stay on the
screen
for say 5 seconds and then close?

Thx

Update Complete Message
 

Perfect
Thanks tom

Andy

"Tom Ogilvy" wrote:

correction - I forgot to use the vbModeless argument


Userform1.show vbModeless
Application.Wait(Now + TimeValue("0:00:10"))
Unload Userform1

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
userform1.Show

Application.Wait(Now + TimeValue("0:00:05"))

Unload Userform1

--
Regards,
Tom Ogilvy


"Andym" wrote in message
...
Hi
Can anyone suggest an option to display a attractive looking message
advising the user that the macro has completed that will stay on the
screen
for say 5 seconds and then close?

Thx