File path from userform text box

[Mikeymike_W]

Hi all,

Could you please tell me how to reference the value in a userform text box as part of a file path?

The file path would be C:\Users\MWa\Desktop\VBA Test\”text box value"

Many thanks in advance,

Mike

 

[Fluff]

Like this

"C:\Users\MWa\Desktop\VBA Test\" & textbox1.value

 

[Mikeymike_W]

Brilliant, thank you for your help

 

[Fluff]

Glad to help & thanks for the feedback