View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cubbybear3 cubbybear3 is offline
external usenet poster
 
Posts: 40
Default Referencing objects inside of a loop

My next problem is:
I have a series of spin buttons (spnVar1, spnVar2, spnVar3) and would
like to reference/change their properties inside a loop. I know this
will not work, but it is basiclly what I need. Also, the spin buttons
do NOT have linked cells.

for each X = 1 to 3
' initialize the value
spnVar(X).Max = X
' reference the value
sheets("Wksht").range("A" & X) = spnVar(X).Min
next X