View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Eef Houniet Eef Houniet is offline
external usenet poster
 
Posts: 4
Default OptionButton. Reset to 0

Muhammed,

Thank you for answering my question.
Your suggestion works for one OptionButton.

I worked this out as follows (I that there are 66 buttons):

Dim tel As Integer
Let tel = 1
Sheets("vragen").Activate
With ActiveSheet
Do While tel < 66
Me.OLEObjects("OptionButton" & tel).Object.value = 0
tel = tel + 1
Loop
End With

However, I think a construction using For Each - Next is better.
Any suggestions?
Thanking you in advance

Eef

"Muhammed Rafeek M" schreef in
bericht ...
try this one:

Me.OptionButton1.Value = True

pls do rate

"Eef Houniet" wrote:

Readers,

Can OptionButtons be set to 0, using something like For each - Next
??

Up till now I know no better way then

Me.OptionButton1 = 0
Me.OptionButton2 = 0
Me.OptionButton3 = 0
Me.OptionButton4 = 0

Thanks,
Eef