Hello Everyone,

I have done some searching to no avail about how to put the activeworksheet
filename into the text of an input/message box.

Does anyone have an idea that could work?

Thanks

msgbox Prompt:="hi " & activesheet.name

or maybe:

msgbox Prompt:="hi there", title:=activesheet.name

Chadersmith wrote:

Hello Everyone,

I have done some searching to no avail about how to put the activeworksheet
filename into the text of an input/message box.

Does anyone have an idea that could work?

Thanks

--

Dave Peterson

Dim S As String

For the worksheet name:
S = ActiveSheet.Name
For the workboook name:
S = ThisWorkbook.Name
For the workbook file name:
S = ThisWorkbook.FullName
MsgBox S


Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Thu, 21 Jan 2010 08:46:11 -0800, Chadersmith
wrote:

Hello Everyone,

I have done some searching to no avail about how to put the activeworksheet
filename into the text of an input/message box.

Does anyone have an idea that could work?

Thanks