Hello all,

I'm trying to read the boolean value of 50 option buttons into column A of a
worksheet so that column A will be, for example
TRUE
FALSE
TRUE
TRUE
.. . . . etc. The following routine does not work, but I don't know why (I
get a runtime error 438):

Sub test()
For i = 1 To 50
Worksheets("Sheet1").Cells(i, 1) = Worksheets("Sheet1").OLEObjects
_("Optionbutton" & i).Value
Next i
End Sub

Later on, I'll want to read the boolean values in column a to change the
value properties of option buttons 1 through 50.

Can anyone help me with this?

Thanks!

Jeff