Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Label
Don't do it. You will be reviled for doing so by anyone who uses your
spreadsheet. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "dcstech" wrote in message ... I have a label in a userform that I would like to blink. I am using a Do While Loop to do this and it works. The problem is that the userform acts like it is locked up and will not except any input. Here is my code. Thanks for any help. dcstech Do While TextBox3.Text = "" Label13.Visible = True newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 1 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime Label13.Visible = False newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 1 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime Loop |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions | |||
Blinking Label | Excel Programming | |||
add text to label (label from forms toolbar) | Excel Programming |