Blinking cells or sounds

[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.

 

[Frank Kabel]

Hi
1. Blinking cells:
- yes this is possible but would require VBA (using an
event )procedure
- search Google for blinking cells
- BUTon'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

 

[William Hyman]

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.

 

[Andy Brown]

Is it possible to have a cell either blink/flash or make a

sound when a condition is met?

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

 

[Frank Kabel]

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

 

[Harald Staff]

Some drawbacks:
- you may have problems to copy and paste
- not sure if the UNDO feature will work
- slows Excel down

You forgot "- will look awful" <g>

Best wishes Harald

 

[Frank Kabel]

You forgot "- will look awful" <g>

Best wishes Harald

Hi Harald
I hped that this was implicit included in my MS statement
<vbg>
nice evening to you
Frank