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 |
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 |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com