Flashing Label using a Timer within a UserForm

[ttt123]

Hi, I would like to be able to have Label, within an Excel UserForm, flash/blink every second or so and change to a different color. However, I do not want it to use a function that waits a specific amount of time since I would like to be doing other tasks concurrently thus leading me to believe a Timer, that trigers an event every second or so, is the best option.
I searched google and people were talking about the Form_Timer() and Form_Current() Subs, but as far as I can tell these Subs are not availiable for UserForms when using VBA for Excel (possibly they are availiable in VB6?). Does anyone know of a Timer function that I could use to make text blink and possibly also make Scrolling Text by changing the Labels position each timer event?

Thanks,
-Taylour

 

[tusharm]

Check out the XL application's OnTime method.

 

[DominicB]

Good morning taylourmackay

You can see an example of the OnTime command here :

http://www.cpearson.com/excel/BlinkingText.htm

The example is not specific to a UserForm label, but shouldn't be difficult to adapt.

HTH

DominicB