Using a VBA forms text box to show the filename path

  • Thread starter Thread starter stevehorton
  • Start date Start date
S

stevehorton

Hi,

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

How can this be done?

cheers

stev
 
Do you mean that you want the saved location of the workbook to b
displayed? If so, use the following.

TEXTBOX1.TEXT = ACTIVEWORKBOOK.FULLNAM



Rolli
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform List box to Text Box 1
How to show time on a form 2
Print Area to include text box 10
Freeze filename and path in cell 2
Text Box 4
VBA - using command button to copy userform text boxes to excel spreadsheet 2
Userform Save data To Worksheet & File 1
Show Filename Only in ComboBox Pulldown 16

Back
Top