Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Buttons to VBA
I have a document that has around 600 Option buttons placed by th
Control Toolbox. I need to find out if there is a way that i can mas edit these in VBA. When I double click them in design mode it simpl brings up a blank vba statement. I need to get at the actual functio of these things, preferably in bulk...as I need to append a shee specification to all the cell links. Any help would be appreciated... Thanks as always, Jason Sel -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Buttons to VBA
Jason,
here is how you can iterate through the buttons Dim obj As Object For Each obj In ActiveSheet.OLEObjects If TypeName(obj.Object) = "OptionButton" Then 'do somethin End If Next obj -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "JasonSelf " wrote in message ... I have a document that has around 600 Option buttons placed by the Control Toolbox. I need to find out if there is a way that i can mass edit these in VBA. When I double click them in design mode it simply brings up a blank vba statement. I need to get at the actual function of these things, preferably in bulk...as I need to append a sheet specification to all the cell links. Any help would be appreciated... Thanks as always, Jason Self --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Buttons frozen | Excel Discussion (Misc queries) | |||
control buttons for chart | Charts and Charting in Excel | |||
Keeping Control Buttons Still | Excel Worksheet Functions | |||
Control Box Option Buttons | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming |