Blinking cells or sounds

  • Thread starter Thread starter William Hyman
  • Start date Start date
W

William Hyman

Is it possible to have a cell either blink/flash or make a
sound when a condition is met? I know you can use
conditional formatting but not the same.
 
Hi
1. Blinking cells:
- yes this is possible but would require VBA (using an
event )procedure
- search Google for blinking cells
- BUT:Don't do this. all methods would slow down Excel
significantly and IMHO blinking cells should not appear in
spreadsheets

2. Play sound:
see: http://j-walk.com/ss/excel/tips/tip87.htm
 
So if I follow you correctly you are saying I should not
want blinking cells period as it will slow me down and I
should just stick to sounds?? I know some VBA so not a
problem. Please confirm.
 
Is it possible to have a cell either blink/flash or make a
sound when a condition is met?
Click to expand...

How about a change event in the sheet module (rightclick the tab, "View
Code")? Something like

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1") = 100 Then
MsgBox "Condition met."
End If
End Sub

HTH,
Andy
 
Hi
yes that was my intention to say:-)
To explain this a little bit more:
If you search Google you'll find some example code (I also
submitted some code for this). All of theses macros use
the OnTime method. this method is called every second to
change the color of the cell. Some drawbacks:
- you may have problems to copy and paste
- not sure if the UNDO feature will work
- slows Excel down

So the sound would be more feasible. As an addition: I
 
Frank Kabel said:
Some drawbacks:
- you may have problems to copy and paste
- not sure if the UNDO feature will work
- slows Excel down
Click to expand...

You forgot "- will look awful" <g>

Best wishes Harald
 
Back
Top