Use this method documented by John Walkenbach:

http://j-walk.com/ss/excel/tips/tip44.htm

While it is written for commandbuttons, the method would work for
optionbuttons as well.

--
Regards,
Tom Ogilvy


"Paul" wrote in message
...
clarification.

The OB's are on a userform.
The values I need placing in the worksheet "Testing" are
(in this instance) numerical - 1 thru 10

The following achieves this, but is very inefficient..

Private Sub OptionButton1_Click()
Worksheets("Idea").Cells(NewRow, "X") = "1"
End Sub

Paul

-----Original Message-----
Where are the optionbuttons - worksheet or userform.

Optionbuttons have a value of true or false. What do you
mean by numerical
or text values - are you talking about the caption?

--
Regards,
Tom Ogilvy

"Paul" wrote in
message
...
Hi, Using XL 2000

I have 10 OptionButtons (with a collective groupname
of 'Status') Each Optionbutton value contains numerical
or
text values. I would like a selected value placed into
my
worksheet using I guess something like this:

Worksheets("Testing").Cells(NewRow, "X") = OptionButton
selected value.

Any ideas appreciated.

Thanks, Paul





.