Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Button Blink????
How do i make for instance ButtonA blink for 3 seconds if a certain
result comes up with the click of Button B???? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Button Blink????
Hi Zach
Give this a try. You will need to create two Command buttons named Commandbutton1 and Comandbutton2. Take Care Marcus Option Explicit Private Sub CommandButton1_Click() Dim i As Integer Do Until i = 3 Application.Wait (Now + TimeValue("0:00:" & i)) If CommandButton2.BackColor = &H8000000D Then CommandButton2.BackColor = &H8000000E ElseIf CommandButton2.BackColor = &H8000000E Then CommandButton2.BackColor = &H8000000D End If i = i + 1 Loop End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make worksheet tab blink? | Excel Programming | |||
Can you make a cell blink? | Excel Worksheet Functions | |||
Make a cell blink | Excel Discussion (Misc queries) | |||
Using VB to make certain field or button blink auto on new data | Excel Programming | |||
Is It Possible To Make A Cell Blink.. | Excel Programming |