Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I want to reset all (control toolbox-)optionbuttons on an excel- worksheet. I've already came to this, but now I'm stuck: Dim obj As OLEObject Dim cnt As Long 'cnt = 0 For Each obj In ActiveSheet.OLEObjects If TypeOf obj.Object Is MSForms.OptionButton Then 'cnt = cnt + 1 ' HERE I HAVE TO SET THE VALUE TO FALSE <<< End If Next 'MsgBox "Number of optionbuttons is " & cnt Am I doing this right so far, or do I have to follow another approach? I really need this as quick as possible... thx... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control ToolBox OptionButtons? | Excel Discussion (Misc queries) | |||
Control ToolBox OptionButtons Printing? | Excel Discussion (Misc queries) | |||
Reset ToolBox | Excel Discussion (Misc queries) | |||
Problem: Control Toolbox Control resizes when clicked | Excel Programming | |||
Controls Toolbox control vs Form Toolbox control | Excel Programming |