Hi

Msg= msgbox("Are you entering data for " _
& Worksheets("OtherSheet").Range("A1").Value & "?")


Regards,
Per

On 22 Jan., 21:19, Chadersmith
wrote:
Hi Ryan/Per

What about an wanting to enter a specific cell's information into the
message box. Even if the cell is in a different sheet...

Thanks,
Chad



"Ryan H" wrote:
This is how you would do it for an Input Message Box:

* * ' get users data
* * MyData = InputBox("Are you entering data for " & ActiveWorkbook.Name &
"?")
* * If MyData = "" Then Exit Sub

This is how you would do it for a Message Box

* * MyData = MsgBox("Are you entering data for " & ActiveWorkbook..Name &
"?", vbYesNo + vbQuestion)
* * If MyData = vbYes Then
* * * * ' do something
* * End If

Hope this helps! *If so, let me know, click "YES" below.
--
Cheers,
Ryan

"Chadersmith" wrote:

Hi Everyone,

I am interested in putting the filename as text in an input/message box. Is
this possible? Something like this perhaps:

msgbox("Are you entering data for ActiveWorkbook.name?")

I know that doesn't work but thought it might help explain my question.