EXCEL Popup - Flash - whatever

[Freckles]

When a a variance appears in a particular cell, I need a "popup" (or some other VERY obvious message) to appear saying

YOU HAVE AN ERROR! YOUR HAVE A #### VARIANCE.

My VBA coding ability is null, but I do copy well.

: Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[JrClown]

use conditional formatting to hightlihg the cell

"The reward of one duty done is the power to fulfill another"
Jr Clwn
​

 

[JrClown]

use conditional formatting to hightlihgt the cell

"The reward of one duty done is the power to fulfill another"
Jr Clwn
​

 

[JrClown]

use conditional formatting to hightlight the cell

"The reward of one duty done is the power to fulfill another"
Jr Clwn
​

 

[mbarron]

Try using the validation function.

Go to Data/ Validation...

Mike

 

[xlhelp]

Freckles.
You can also use code.

To paste it, go to Tools, Macro, Visual Basic Editor. In the left pane double click on the Sheet name that you want this Pop up to take place for. And paste the code. This code works when anything on that particualr worksheet changes. (This test the value in cell B3. You can change it for whichever cell you like.) Here is the code.

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("B3&quot.Value > 0 Then
MsgBox "You have a Positive Variance"
End If
If Range(&quot;B3&quot < 0 Then
MsgBox &quot;You have a Negative Variance&quot;
End If
End Sub

 

[Freckles]

First, Thanks to all who responded. AND mbarron, you pointed me to a whole new set of possibilities. AND xlhelp, you gave me what I thought was all that was available.

: Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.