View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.morriss@wlucy.co.uk is offline
external usenet poster
 
Posts: 5
Default Option Button Grouped

I have a option button and label grouped and what of set the option
button to value xlon. I cannot seem to be able to set the value when
it's grouped.

I have been trying this which finds the option button but will not set
the value.

Dim ob As OptionButton

For Each ob In ActiveSheet.OptionButtons
If ob.Name = "Group 498" Then
ob.Value = xlOn
End If
Next


I get error 'Run-time error 1004': Unable to set the value property of
the optionbutton class.

Can somebody tell me where I'm going wrong.

Thank you.