Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
OLE Objects | Excel Discussion (Misc queries) | |||
VBA Objects | Excel Discussion (Misc queries) | |||
Objects and Variables | Excel Programming | |||
Changing objects on other Worksheets with Variables | Excel Programming |