View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff H Geoff H is offline
external usenet poster
 
Posts: 2
Default Objects and Variables

I have problem that bugs the hell out of me.

Is there some way of accessing an object by a variable name? ie
instead of
frmMain.cbParts1.value up to frmMain.cbParts10.value

use a variable to give

frmMain.("cbParts" & iCount).value

to loop through them. I have tried using the Controls but it
sometimes results in the controls out of sequence so that I address

cbParts7
cbParts1
cbParts2
cbParts3
cbParts4
cbParts5
cbParts6
cbParts10
cbParts8
cbParts9

which when filling in a form isnt that great.

Is there any way to use a variable in an objects name?

Thanks in advance

Geoff