OptionButtons
Option buttons are usually linked to a specific cell. Say this cell is M1.
When you click on the 1st option button, M1 will be 1; the 2nd o.b. will
make M1 a 2, etc.
You can take advantage of this by having the list of option buttons' values
and do something like:
Worksheets("Testing").Cells(NewRow, "X") = Array("OptionButton 1
text","OptionButton 2 text","...","Option Button 10
text")(Range("M1").value)
Bob Umlas
Excel MVP
"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
|