Message/Input Box - filename in question text?
 

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

Message/Input Box - filename in question text?
 

Hi Chad

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

Regards,
Per



On 21 Jan., 19:02, 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.

Thanks,
Chad

Message/Input Box - filename in question text?
 

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.

Thanks,
Chad

Message/Input Box - filename in question text?
 

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.

Thanks,
Chad

Message/Input Box - filename in question text?
 

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.