formula that r will make a warning sound when the cell has a particular value

  • Thread starter Thread starter Upula Prematunga
  • Start date Start date
U

Upula Prematunga

Is it possible to format a cell or use a formula so that the computer will
make a warning sound when the cell has a particular value? Only an instant
beep is required at the time of change, not a permanent one.
Rgds
 
Upula Prematunga said:
Is it possible to format a cell or use a formula so that the computer will
make a warning sound when the cell has a particular value? Only an instant
beep is required at the time of change, not a permanent one.
Rgds
Click to expand...

No. Formats and formulas work on the STATE of the workbook. As you correctly
identify, you want something to happen on an EVENT. That requires a macro.
 
You can use the worksheet Change event which runs each time a cell valu
is changed. You might also want to check if the changed cell is part o
some range. Something like :-

'----------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Not Application.Intersect(Target, Range("A1:Z50")) Is Nothing _
And Target.Value >= 100 Then Beep
End Sub
'-------------------------------------------------------
 
Back
Top