Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good day all, i would like to "Flash" a msg on a form and i have used
the following which works, it is just too slow and need it to flash quicker... Can anybody help please ? Sub test4() With UserForm2.Label1 .Caption = "ERROR" .Font.Name = "Arial" .Font.Size = 14 .Font.Bold = True .WordWrap = True .BackColor = RGB(253, 7, 100) End With Application.OnTime Now + TimeValue("00:00:01"), "test5" End Sub Sub test5() With UserForm2.Label1 .Caption = "" .Font.Name = "Arial" .Font.Size = 14 .Font.Bold = True .WordWrap = True .BackColor = RGB(255, 255, 255) End With Application.OnTime Now + TimeValue("00:00:01"), "test4" End Sub Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel to Play Flash Animation or GIF in User Form??? | Excel Programming | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
FLASH CHART is possible | Charts and Charting in Excel | |||
EXCEL 2002: How do I user/simulate a Timer event in Excel form | Excel Programming | |||
EXCEL 2002: How do I user/simulate a Timer event in Excel form | Excel Programming |