Results 1 to 2 of 2
2002-10-16, 10:04 #1
- Join Date
- Jan 2002
- London, Gtr London, England
- Thanked 0 Times in 0 Posts
Userforms, variables & multiple documents (WORD 97/2000)
I have a template that contains two userforms (created using the VBA under WORD2000/97), i.e. Userform1 and Userform2. I have also defined my own macros and some 'Public' varaibles that I use within these macros.
When I open a document (using the defined template) it displays a form 'Userform1' to the screen and gets information from the user which populates some custom properties. It also sets up some 'public' variables (defined as Public p_FileSaved As Boolean & Public p_PostProcess As Boolean) on top of a module.
If I open another document using the same template, I find that the Userform1 takes its properties from the first document opened and the public variables also contain the values updated by opening document 1 (whereas I would have expected it to have default values for the second document - which I would update after displaying the Userform1 to the screen for the 2nd document). I hope the above makes sense.
I would have expected that document1 and document2 would have its own Userform1, Userform2, public variables p_FileSaved, p_PostProcess but it seems to share these between both/multiple documents? Any ideas why and what is the potential solution please. Surely, even though the forms are designed within a template, each opened document should have a copy of its own Userform1, Userform2 and the public variables.
I have also found that when I try to display the form on the second document (using a macro), it first jumps to the first document, display the form but contains properties from the second document. It doesn't update the document correctly even if properties have changed. This is a real muddle & pain.
I am in a real jam here so any ideas would be more than welcomed.
Please tell me if I am doing something wrong or I need to set something up to indicate the each document should have its own "workspace of userforms and variables".
Thanks in advance.
2002-10-16, 10:14 #2
- Join Date
- Nov 2001
- Thanked 7 Times in 7 Posts
Re: Userforms, variables & multiple documents (WORD 97/2000)
You get this problem If you hide the form after using it in Document 1.
After you finish using the form in Document 1 you must unload it. Then it will load a new instance of the form when you show it from Document 2.