[RESOLVED] EXCEL: Pop-Up Box when value goes over or below a certain value.

[rsutt1]

Hello again,

I need to creat a pop up box to warn a user that a value has gone below a certain point.

I also need to create one that warns the user when value is over a certain value.

Any ideas welcome

[Siddharth Rout]

if you mean a message box then use the following code...

Private Sub Command1_Click()
certainvalue = 6
checkvalue = 5
If checkvalue < certainvalue Then
    MsgBox "The value is less than " + Str(certainvalue)
End If
End Sub

same applies for 'over a certain value'

Private Sub Command1_Click()
certainvalue = 5
checkvalue = 6
If checkvalue > certainvalue Then
    MsgBox "The value is Greater than " + Str(certainvalue)
End If
End Sub

you can modify the code as per your requirements...

[rsutt1]

Many Thanks, I appear to be getting the hang of this now!!