Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
While trying to make changes to a large number of option buttons on a sheet,
I want to increment a number and concactinate it in order to change the correct optionbutton. But this does not work: Sub MySub dim i i = 1 for i = 1 to 200 MyOB = "OptionButton" & trim(str(i)) MyOB.value = False 'or any of the other properties I need to change next i end It does work when I use the actual optionbutton name instead of the variable, i.e. OptionButton2.value = False -JEFF- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |