PDA

View Full Version : Resetting Userform Default Text Value Via VBA



Loren
08-06-2019, 10:06 AM
Hello,

I am trying to write a sequence generating word program that uses a userform to select the unit configuration and set points. Once the user has completed their work and generated the sequence, I need to reset the default text values in the userform properties so that when the file is closed and re-opened the unit configuration form is exactly as they left it. I know how to manually set the default text values in the properties of the userform but I need to do it via VBA for this project.

24762

Loren

gmaxey
08-06-2019, 11:35 AM
Seems you could store the values they entered in document properties or a customXMLPart then use the form initialize event to set the text and value properties from the stored values.

Loren
08-12-2019, 05:16 AM
Thanks for the help everyone. I think I will proceed with the document properties option.