Creating an Alert Box

  • Thread starter Thread starter Paul987
  • Start date Start date
P

Paul987

I would like to create an Alert box that would pup up when a specific
event occurs. For instance if cell A2 >1 , then a box would pop up,
and state "a2 > 1" and require acknowledgement. Maybe even ding until
click off. Is this possible? I would like to do it w/o VBA so it can
be more flexible and can be created easier by an end user. Any
advice?
TIA
Paul
 
Use Data Validation with either a number <= 1 or a custom formula of

=A2<=1

No ding though.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thanks, Bob. I didn't even know that feature existed. It's people like
you that keep this site running!
 
New problem. The cell I was going to use the data validation on is real
time data. Therefore, the user isn't entering a value into the cell,
it's changing automatically and the validation doesn't work. Any
ideas?
 
Here's another idea Paul.

Link a cell to the cell that gets update via the feed, with a simple =H10
say.

Add this code, which should trigger when the linked cell, A1 in my example,
goes below 1

Private Sub Worksheet_Calculate()
Const WS_RANGE As String = "A1:H10"
Static oldvalue

If Me.Range(WS_RANGE) <> oldvalue Then
If Me.Range(WS_RANGE).Value <= 1 Then
MsgBox "Alert"
End If
End If
oldvalue = Me.Range(WS_RANGE).Value
End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Bob - Unless I'm misunderstanding something, I'm not sure the macro will
work because the data will be constantly changing, several times a
second, and the macro will only run on command or a time loop of some
sort. Is this correct? Thanks for the help.
 
Back
Top