Solved: POP UP Message when a criteria is met

[jenroyce]

Hi,

I would like to create a program where in if a cell meets a criteria it will post a message banner in a person's desktop and the person will have an option to higher or lower the opacity, to display or not display as "always on top" or not.

So far i've attached what i was able to do.

Its just a tiny pop up message and it doesnt automatically run when the criteria is met

Hoping someone can help.

[shrivallabha]

Use following type of event. This needs to be placed in Sheet1(1) module as it is worksheet specific.
[vba]Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$7" Then
Select Case Target.Value
Case 7
MsgBox "Well"
Case Is >= 10
MsgBox "YOU ROCK!!!"
End Select
End If
End Sub
[/vba]