Hi,
I'm trying to have a reminder message pop up when a certain cell is
selected. I would like to do this with VBA as opposed to doing it with
a Data Validation input message. I've tried the following code but to
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 cell
A1? Normal setting is 25."
End If

End Sub

I get the following error message:

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

Function call on left-hand side of assignment must return Variant or
Object
---------------------------
OK Help
---------------------------


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=469251