Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In Module "This Workbook" I've declared a global variable using the following
statement: Public mSelection As Integer In a UserForm, I've assigned a value to the variable using the following statement: Private Sub btnSprintSubmit_Click() mSelection = lbSprint.ListIndex End Sub Now, in ANOTHER UserForm, I have a Case Statement that fills in all of the labels on the UserForm, based on the value of mSelection. But, when I step through the code in that UserForm, the value of mSelection is "Empty". How come the value of mSelections isn't passing from one UserForm to the next? Am I declaring the global variable incorrectly? Any help/advice/tips are greatly appreciated! Thank you -Allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Create Global Variables in a module | Excel Programming | |||
Global module | Excel Programming | |||
Global variable | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |