Variable in Message Box Q

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 10 Nov 2007 11:00 GMT

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

Reply to this Message

Jay - 10 Nov 2007 11:16 GMT

Hi Sean -

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

---
Jay

> 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
[quoted text clipped - 11 lines]
>
> End Sub

Reply to this Message

Sean - 10 Nov 2007 12:13 GMT

Thanks Jay, its that simple!

Reply to this Message