Global (Module) Variable Problem

[Guest]

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

 

[Chip Pearson]

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


message
news:[email protected]...

 

[Guest]

Perfect. Thanks a million Chip!!!!

-Allen

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


message