Ok...so a couple of things.
1. You need to set the value of the textbox upon initialization of the userform. This is accomplished via:
(Copy Paste in same location as your other form code)
2. I switched your variable declaration to String from Variant as a file path is exactly that, a string. The revised CommandButton1_Click would then look like:
I'm not sure about your TextBox1_Change code. I am fairly certain that if its creation was an attempt to do what we have just done, it is now unnecessary and can be removed.
Hope this helps.
Bookmarks