Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Rerun Module (2002/2003/2007)

    Through the help of this lounge, I have VBA code in a template that displays a form to be filled out to populate header information. This works great for a new document.

    Now that documents have been created from the template, we would like a way to rerun the VBA form to update the information for the header. Is there a way to run that form and code within the document?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Rerun Module (2002/2003/2007)

    You could create a macro in the template like this:

    Sub ShowForm()
    UserForm1.Show
    End Sub

    where UserForm1 is the name of the form. The macro can be run from all documents based on the template.
    But whether this will do what you want depends on how the information is stored in the document.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Rerun Module (2002/2003/2007)

    Thanks, Hans

    This works just great. I will have my users check this solution.

Posting Permissions

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