Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up message depending on cell value
is it possible to have different messages automatically pop up depending on
certain cell values. e.g. if a1=6 a message would pop up with "correct", if a1=7 a message would pop up with "incorrect", if a1=8 a message would pop up with "try again" etc. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up message depending on cell value
In VB Editor (ALT-F11) double click Sheet1, then paste
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then If Target = 6 Then MsgBox "Correct" ElseIf Target = 7 Then MsgBox "Incorrect" ElseIf Target = 8 Then MsgBox "Try again" End If End If End Sub "John Davies" schreef in bericht ... is it possible to have different messages automatically pop up depending on certain cell values. e.g. if a1=6 a message would pop up with "correct", if a1=7 a message would pop up with "incorrect", if a1=8 a message would pop up with "try again" etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum a value depending on the value of a cell?? | Excel Worksheet Functions | |||
Add a row depending on cell value | Excel Worksheet Functions | |||
Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
Automated cell copy depending on cell content? | Excel Programming |