Variable in Message Box Q

[Sean]

I have a very simple Message Box that appears when a file is opened.
How could I have a variable referred to within this message box e.g if
my text to appear in the message box was referenced to G1 in sheet
"Sales"?

Thanks



Private Sub Workbook_Open()

MsgBox "Maximise Sales for w/c 05/11/07"
Range("A1").Select
Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub

 

[Guest]

Hi Sean -

MsgBox "Maximise Sales for " & Worksheets("Sales").Range("G1")

 

[Sean]

Thanks Jay, its that simple!