Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the same variable in separate userform modules
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing variable values to userform control | Excel Discussion (Misc queries) | |||
Calling a Userform from a Predefined Variable | Excel Worksheet Functions | |||
Userform and variable | Excel Discussion (Misc queries) | |||
Defining UserForm Caption from a Variable | Excel Worksheet Functions | |||
Userform button setting variable from formula | Excel Discussion (Misc queries) |