Using a VBA forms text box to show the filename path

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
 
R

Rollin_Again

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
 
Top