Clearing data from a Userform when completed

[nurds]

I have created a Word Template using a table that is populated using a
Userform. It all works fine, but when I close the file down and then re-open
it to use it again, the Userform appears with all the previous data still in
it. Am I able to add a line of code that clears all the data from the
userform once the file is closed, thereby leaving a blank userform each time
the file is re-opened? This even applies if I don't save the file upon
closing. Any help on this would be much appreciated.
Thanks.

 

[Karl E. Peterson]

I have created a Word Template using a table that is populated using a
Userform. It all works fine, but when I close the file down and then
re-open it to use it again, the Userform appears with all the
previous data still in it. Am I able to add a line of code that
clears all the data from the userform once the file is closed,
thereby leaving a blank userform each time the file is re-opened?
This even applies if I don't save the file upon closing. Any help on
this would be much appreciated.

Create and use new *instances* of the UserForm, rather than repeatedly
calling the autoinstantiated default instance. IOW, when you want to show
it, do this:

Dim frm As FMyUserForm
Set frm = New FMyUserForm
' set any custom properties
frm.Show

Then, to get rid of it:

frm.Hide 'Assuming this isn't done from within
Set frm = Nothing

Later... Karl