Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm a hopeless beginner and have the following problem: I'm trying to return properties of optionbuttons which are on a Excel Worksheet by adressing them with varibles. The Optionbuttons are Named "OptionButton1" etc. This doesn't work: ButtonCounter = 1 Do While ButtonCounter < 300 MyButton = "OptionButton" & ButtonCounter If Sheets(3).MyButton.GroupName = ItemNo Then Do something End if ButtonCounter = ButtonCounter + 3 Loop I tried any syntax I could think of. Can anybody tell me how I can return properties of an optionbutton adressing it by means of an int variable |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Definitions for Activex control properties? | Excel Worksheet Functions | |||
Return a value if variable is in a range | Excel Discussion (Misc queries) | |||
Return a Variable value length | Excel Worksheet Functions | |||
How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
ActiveX Chart Properties in Excel 2000 | Excel Programming |