Excel Conditional Popup Message

[shickey]

HI,

I have a worksheet with 3 cells in it. One cell is "Total", the second cell is "Adjustment" and the third cell is "Variance".

How can I create a popup message that states "Adjustment is Below the Total" and show the variance in the Variance cell in the event that the Adjustment value is below the Total value ?

Thanks
Shickey

 

[DRJ]

Hi - Welcome to the board

You can try something like this in the worksheet change events

If adjustment < total then
msgbox "Adjustment is Below the Total"
end if

Post back with the ranges of these calculations if you need more help.

 

[shickey]

HI


Thanks for the help....yep,,,,,I be a newbie

Here is what I poked in. It didn't work. Did I poke it in right ?

Private Sub Worksheet_Change(ByVal Target As Range)
If h20 < h19 Then
MsgBox "Adjustment is Below the Total"
End If
End Sub



Thanks

 

[DRJ]

Close, try this instead.

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Range("H20").Value < Range("H19").Value Then
        MsgBox "Adjustment is Below the Total"
    End If

End Sub

 

[shickey]

HOT ****....YOU DA MAN !!!!


ray:
Thanks

 

[shickey]

Hi,

Got one little snag. If H20 is 0 (zero), I get a runtime 13 error. Do you know how to adjust the formula so a zero does nothing but entry into H20 creates the conditional popup message ?



Thanks

 

[Yogi Anand]

Hi Shickey:

I do not get any run time error with H20 as 0. However you can use the following modification for no message in case H20 is 0 ...

Private Sub Worksheet_Change(ByVal Target As Range)
    If Range("H20").Value <> 0 And Range("H20").Value < Range("H19").Value Then
        MsgBox "Adjustment is Below the Total"
    End If
end sub

 

[shickey]

Thanks Guys

ray:

 

[DRJ]

You're Welcome

Take Care

 

[Colin904]

I was wondering if someone could help me. I have created a spreadsheet that compare a rolling expenses spend to a budget. I have setup condition monitoring so that if the spend is 0-75% of budget the 'spendtodate' field is green, 75-90% its amber and 90+% is goes red.
I am trying to get excel to throw up a warning box to the user if the field goes red. So he knows he is near the upper limit of his budget.
Regards,
Colin