Splash Screen Flashing Label Problem

[Guest]

I put the code in the Activate of the UserForm & created a Sub Flash() to get
the label flashing on the UserForm with a Close button to unload the form as
instructed.

The Userfrom is loaded for a few seconds per the Initialize & then Unloads
automatically per code, but the label seems to still be flashing.

How do I get this flashing label to stop when the form unloads automatically
per code without using the close button.

 

[Tushar Mehta]

You need to either continue the discussion in which you got the code
you are using or you need to share the code in this new discussion.

I suspect you need to cancel the scheduled timed event. Assuming you
are using the OnTime method and have saved the time of the next event,
call OnTime again with the saved time and the last argument set to
false. If you are using the Windows Timer API, use the KillTimer call
to terminate the timer using the ID returned by the SetTimer procedure.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Bob Phillips]

See response to original thread.

--

HTH

RP
(remove nothere from the email address if mailing direct)