Consulting

Results 1 to 3 of 3

Thread: Resetting Userform Default Text Value Via VBA

  1. #1
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    2
    Location

    Resetting Userform Default Text Value Via VBA

    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.

    TextToChange.PNG

    Loren

  2. #2
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    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.
    Greg

    Visit my website: http://gregmaxey.com

  3. #3
    VBAX Newbie
    Joined
    Aug 2019
    Posts
    2
    Location
    Thanks for the help everyone. I think I will proceed with the document properties option.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •