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
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