Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global (Module) Variable Problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global (Module) Variable Problem
Take the variable mSelection out of the ThisWorkbook module and
put it in a standard code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Allen Geddes" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global (Module) Variable Problem
Perfect. Thanks a million Chip!!!!
-Allen "Chip Pearson" wrote: Take the variable mSelection out of the ThisWorkbook module and put it in a standard code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Allen Geddes" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |