Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Recently I have been needing to use some global variables but I dont know how
to do it, colud some one explainme how to achive this. Also: I have a form (userform1); this form has 2 chek boxes inside a grouop box, If chekbox1 is cheked, then I want that the variable a save the "1" value on it (dim a as integer -- a=1) and if chekbox2 is cheked then a saves "2", this values of "a" I use them in one of my macros after a button in userform1 is pressed (button1--unload userform1). Now the problem; My problem is when userform1 is unloaded, a lost is value, so I dont know which value ; how to accomplish what I want???? |
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 | |||
Problems Defining Object Variable in For Each Loop | Excel Programming | |||
Defining a variable within a sub... | Excel Programming | |||
Defining a variable within a sub... | Excel Programming | |||
Defining a Variable | Excel Programming |