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

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/