Userform initializes more than once.

[MCCCLXXXV]

I have code in Module1 that calls OpenFileUF.Show (my userform). the code in the userform has property code so that I can Get and Let. In cdbOK_Click, I have Unload Me to unload the userform. In Module1, I call OpenFileUF.sPath sometime after I show the userform to get a path string. when i call this, the userform re-initializes. because it re-initializes, it replaces all the data that the user inputted when it was shown and therefore returns the wrong sPath string.

[shg]

Unload releases the form from memory, and so clears all the data not set a design time.

Try the Hide method instead of Unload. The form will retain its data while hidden, and not trigger the Initialize event when shown.

[MCCCLXXXV]

thats what i was thinking but is that the proper way to get data out of a userform after the user clicks OK?

[shg]

Pardon ...?

[Andy Pope]

Try this approach. use a object variable to reference the userform.
You Hide the userform when done, which returns control to the Test routine.
Then once you have the information from the userform you can unload and remove from memory.

Module code

Please Login or Register  to view this content.

Userform contains 1 commandbutton and read-only property to return current folder.
Userform code

Please Login or Register  to view this content.

[MCCCLXXXV]

that seems to work. thanks