text box to show current filename in VBA form

stevehorton09 · Jul 27th 2004

Hi,

I want that when i launch my userform the activesheet saved location is shown in a text box (textbox1)

How can this be done?

cheers

steve

lasw10 · Jul 27th 2004

Quote

activesheet saved location

??

Do you mean the workbook file path?

so in the userform show event

set the value of the textbox to be : activeworkbook.fullname

**royUK** · Jul 27th 2004

Something like

TextBox1.Text = ThisWorkbook.Name & ThisWorkbook.Path

stevehorton09 · Jul 27th 2004

yes, i put that in the value but it did not work,

i tried roys and it keep picking up the wrong file name (gives the other open sheet) ? Where in my code should i have this???

**royUK** · Jul 27th 2004

Are you talking about worksheets or workbooks?

this will show the workbook's name and path and active sheet name in a messagebox when the Workbook is opened.

Code

Option Explicit
Sub Comment_text_2_Cell()
' Written by royUK
'   [url]www.excel-it.com[/url]


Option Explicit


Private Sub Workbook_Open()
MsgBox ThisWorkbook.Name & Chr(10) & ThisWorkbook.Path & Chr(10) & ActiveSheet.Name
End Sub

Display More

stevehorton09 · Jul 27th 2004

ok got it now, i have been using a workbook and from your excellent help i have done this!!

Thanks very much

text box to show current filename in VBA form

Participate now!

Share