Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having problems transferring a variable from a form back to a module.
My module is: Public invP, vP Sub Mod() .. .. UserForm6.Show MsgBox invP & vP .. end sub Private Sub CommandButton1_Click() .. invP = ListBox1.ListIndex + 1 vP = ListBox2.ListIndex + 1 .. end sub In the routine CommandButton1 invP=1 and vP=3 when the control returns to the routine Mod they both equal zero. Any ideas why and how to make them behave? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer variable to user Form | Excel Discussion (Misc queries) | |||
Access variable from form and module? | Excel Programming | |||
Unload A Form based on a Variable in my Module | Excel Programming | |||
Transfer control to new module in macro | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |