Resetting Textbox Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ms.My - 25 Jan 2005 01:03 GMT

I have a macro that calls userforms. How do I clear the values from
textboxes the next time the user runs that same macro? How do I tell Word to
reset/refresh everything?

Reply to this Message

Jean-Guy Marcil - 25 Jan 2005 03:59 GMT

Ms.My was telling us:
Ms.My nous racontait que :

> I have a macro that calls userforms. How do I clear the values from
> textboxes the next time the user runs that same macro? How do I tell
> Word to reset/refresh everything?

You have to use the Unload method in your code, not just Hide/Show.

Near the end of the code, it the userform is being closed by a button on it,
use

Unload Me

Or, if the closing is external to the useform, use

Unload UserFormName

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message