Message/Input Box - filename in question text?

[Chadersmith]

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.

Thanks,
Chad

 

[Per Jessen]

Hi Chad

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

Regards,
Per

 

[Ryan H]

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.

 

[Chadersmith]

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

 

[Per Jessen]

Hi

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


Regards,
Per