Software

Ask something
Question Locked

Blinking Text

0 helpful
2 replies

by lost4now

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I seem to remember that in an older version of Excel that you could make the text blink via conditional formatting. Am I wrong?
Can this be done in the Excel 2003 and newer?

2 replies

by peconet tietokoneet

Excel doesn't have blinking text. Better to change the background colour to yellow or such to indicate its importance.

You can do this with the Initialize event and the Change event, for example:

Code:

' // When form loads highlight the field
Private Sub UserForm_Initialize()
Me.TextBox1.BackColor = vbYellow
End Sub

' // When user enters data, turn it back to white background
Private Sub TextBox1_Change()
Me.TextBox1.BackColor = vbWhite
End Sub

Thank you to medialint for this code.

This discussion is closed to new replies.