Thread
:
Using the same variable in separate userform modules
View Single Post
#
2
Posted to microsoft.public.excel.programming
papou[_6_]
external usenet poster
Posts: 5
Using the same variable in separate userform modules
Hello Darren
Not too sure about public variables on userforms!
I would simply suggest that you declare these variables in the declarations
section of a standard module.
HTH
Regards
Pascal
"DarrenW" a écrit dans le message
de news:
...
Hello all,
Here's my question, I have created 2 userforms, the first is the main
one used simply for data entry and some calculations.
The second userform is called from the first userform using the Show
command, this is used to perform a simple search on the already
entered data and get a row number on a match.
I have defined 2 Public variables in the declarations section of the
first userform
Public CurRow as string
Used to store the row number
Public LoadJob as boolean
Used to tell if the user wants to load the data, True to load, False
to not load.
The Subs in the second userform module can see these variables and
assign them values (I'm assuming they can because I get no error
messages) however when I return to the first userform module after the
Show command the variables have been reset.
Are the assigned values only valid during the second modules scope of
operation?
Any ideas or suggestions would be appreciated
Thanks
DarrenW
Reply With Quote
papou[_6_]
View Public Profile
Find all posts by papou[_6_]