| 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 |
| 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)
Threaded Mode
