Thread
:
Using the same variable in separate userform modules
View Single Post
#
3
Posted to microsoft.public.excel.programming
Jose Rojas
external usenet poster
Posts: 16
Using the same variable in separate userform modules
try on Module1
Option Explicit
Public Type DistributorData
dName As String
dUserID As Long
End Type
and at the top of the form type
Dim Dist as DistributorData
J.Rojas
"papou" wrote in message
...
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
Jose Rojas
View Public Profile
Find all posts by Jose Rojas