UNDERSTANDING VARIABLE SCOPE
Hey Jim,
That shouldn't be it. It would be true if the variables were declared in the
form, but if the variables are declared in a normal code module, as the OP
states, their scope extends beyond the life of the form.
It sounds as if the OP has also declared them as class variables in the
form, and so the form uses them, but that is just a guess.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jim Thomlinson" wrote in message
...
The values in the form are being discarded because you are unloading the
form. Instead of unloading the form just hide it. By doing this the values
will not be lost and you will not need to store them anywhere. The next
time
you show the forms it look just like th user left it before it was hidden.
--
HTH...
Jim Thomlinson
"-JEFF-" wrote:
I am trying to maintain variables value so when I return to a userform
that
has already been used, it will already be filled out (as long as the
user has
previously visited it. I thought declaring the variables as public at
the
module level would make them visible in all subs but it is not working.
In module 3 I have variables declared as public. In the sub, the
variables
are not declared because I want to use to publics but they seem to get
over
written when they are assigned a value. ie.
MODULE 3
public v1 as string
public v2 as string
private sub MyButton_click()
v1 = "myValue"
v2 = "myValue"
end sub
The watch window shows <Out of context after values have been assigned
inside the sub.
|