Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouped Items won't Stay Grouped When Moving Object | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button | Excel Programming | |||
Option button | Excel Programming | |||
Option Button Value | Excel Programming |