View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default problems defining a global variable

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????