Filename in Input/Message Box

  • Thread starter Thread starter Chadersmith
  • Start date Start date
C

Chadersmith

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
 
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]
 
Back
Top