PDA

View Full Version : Solved: POP UP Message when a criteria is met



jenroyce
02-01-2011, 09:30 PM
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
02-02-2011, 03:59 AM
Use following type of event. This needs to be placed in Sheet1(1) module as it is worksheet specific.
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