Display Path on userform

[sowetoddid]

Is it possible to display the default saveas path on a userform?

[dominicb]

Good evening Sowetoddid

Sure is! All you need to do is set up a label on your user form and call it (say) label1. then put this code in the Private Sub UserForm_Activate() event procedure. This will ensure that the path is picked up when the Userform displays.

Label1.Caption = Application.DefaultFilePath

And that's it.

HTH

DominicB