C
Casey
Hi,
I'm trying to have a reminder message pop up when a certain cell i
selected. I would like to do this with VBA as opposed to doing it wit
a Data Validation input message. I've tried the following code but t
no avail. Here's the code followed by the error message.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row = 5 And Target.Column = 6 Then
MsgBox = "Have you verified your Extra Material setting in cel
A1? Normal setting is 25."
End If
End Sub
I get the following error message:
I'm trying to have a reminder message pop up when a certain cell i
selected. I would like to do this with VBA as opposed to doing it wit
a Data Validation input message. I've tried the following code but t
no avail. Here's the code followed by the error message.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row = 5 And Target.Column = 6 Then
MsgBox = "Have you verified your Extra Material setting in cel
A1? Normal setting is 25."
End If
End Sub
I get the following error message: