| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Object Names with Variable
Hello, I'm trying to loop through objects (CheckBox controls) on a worksheet using a variable in the name. Based on the syntax for UserForm controls, I'm trying For x = 1 to 10 Worksheets("Sheet1").Controls("CheckBox" & x).Visible = True Worksheets("Sheet1").Controls("CheckBox" & x).Enabled= True Next This gives me Run-time Error 438 "Object doesn't support this property or method. Thanks for your help! -- jbl25 ------------------------------------------------------------------------ jbl25's Profile: http://www.excelforum.com/member.php...fo&userid=7225 View this thread: http://www.excelforum.com/showthread...hreadid=399298 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Object Names with Variable
jbl25,
Replace "Controls" with "OLEObjects" and it should work. hth, Doug "jbl25" wrote in message ... Hello, I'm trying to loop through objects (CheckBox controls) on a worksheet using a variable in the name. Based on the syntax for UserForm controls, I'm trying For x = 1 to 10 Worksheets("Sheet1").Controls("CheckBox" & x).Visible = True Worksheets("Sheet1").Controls("CheckBox" & x).Enabled= True Next This gives me Run-time Error 438 "Object doesn't support this property or method. Thanks for your help! -- jbl25 ------------------------------------------------------------------------ jbl25's Profile: http://www.excelforum.com/member.php...fo&userid=7225 View this thread: http://www.excelforum.com/showthread...hreadid=399298 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
| Pivot Table - Object variable or with block variable not set? | Excel Programming | |||
![jbl25[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
