msgbox and range name

[jaypatel]

Hi,

Below is a macro that i have done:
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Do you want to continue & order1?" ' Define message.
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "MsgBox Demonstration" ' Define title.
Help = "DEMO.HLP" ' Define Help file.
Ctxt = 1000 ' Define topic
' context.
' Display message.
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then ' User chose Yes.
MyString = "Yes" ' Perform some action.
Else ' User chose No.
MyString = "No" ' Perform some action.
End If

The problem I have is the msg part. I have a range name called order1 (Cell contents could be "today" or "tomorrow"and I would like the message to read "Do you like to continue today?" or "do you like to continue tomorrow?". Of course the cells contents in order1 can vary.

Cheers

Jay

 

[d-alan]

Try:
Msg = "Do you want to continue "& range("order1")& "?" ' Define message.
-D

 

[jaypatel]

Thanks for that