software

I would like to create an Alert box that would pup up when a specific
event occurs. For instance if cell A2 gt;1 , then a box would pop up,
and state quot;a2 gt; 1quot; 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--
Paul987
------------------------------------------------------------------------
Paul987's Profile: www.excelforum.com/member.php...oamp;userid=24850
View this thread: www.excelforum.com/showthread...hreadid=520206Use Data Validation with either a number lt;= 1 or a custom formula of

=A2lt;=1

No ding though.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Paul987quot; gt; wrote in
message ...
gt;
gt; I would like to create an Alert box that would pup up when a specific
gt; event occurs. For instance if cell A2 gt;1 , then a box would pop up,
gt; and state quot;a2 gt; 1quot; and require acknowledgement. Maybe even ding until
gt; click off. Is this possible? I would like to do it w/o VBA so it can
gt; be more flexible and can be created easier by an end user. Any
gt; advice?
gt; TIA
gt; Paul
gt;
gt;
gt; --
gt; Paul987
gt; ------------------------------------------------------------------------
gt; Paul987's Profile:
www.excelforum.com/member.php...oamp;userid=24850
gt; View this thread: www.excelforum.com/showthread...hreadid=520206
gt;

Thanks, Bob. I didn't even know that feature existed. It's people like
you that keep this site running!--
Paul987
------------------------------------------------------------------------
Paul987's Profile: www.excelforum.com/member.php...oamp;userid=24850
View this thread: www.excelforum.com/showthread...hreadid=520206
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?--
Paul987
------------------------------------------------------------------------
Paul987's Profile: www.excelforum.com/member.php...oamp;userid=24850
View this thread: www.excelforum.com/showthread...hreadid=520206Here'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 = quot;A1:H10quot;
Static oldvalue

If Me.Range(WS_RANGE) lt;gt; oldvalue Then
If Me.Range(WS_RANGE).Value lt;= 1 Then
MsgBox quot;Alertquot;
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)

quot;Paul987quot; gt; wrote in
message ...
gt;
gt; New problem. The cell I was going to use the data validation on is real
gt; time data. Therefore, the user isn't entering a value into the cell,
gt; it's changing automatically and the validation doesn't work. Any
gt; ideas?
gt;
gt;
gt; --
gt; Paul987
gt; ------------------------------------------------------------------------
gt; Paul987's Profile:
www.excelforum.com/member.php...oamp;userid=24850
gt; View this thread: www.excelforum.com/showthread...hreadid=520206
gt;

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.--
Paul987
------------------------------------------------------------------------
Paul987's Profile: www.excelforum.com/member.php...oamp;userid=24850
View this thread: www.excelforum.com/showthread...hreadid=520206
one more question: How do I stop it, so I can modify the code?--
Paul987
------------------------------------------------------------------------
Paul987's Profile: www.excelforum.com/member.php...oamp;userid=24850
View this thread: www.excelforum.com/showthread...hreadid=520206