Hi Nev
First you must have each seperate groups of button surronded by a Group Bo
1) Right click one of the buttons in the group
2) Select "Format Control" and go to the Control ta
3) Assign a linked cel
Now the linked cell will display a number corresponding to the selected button. You can now use an IF statement or LOOKUP function with the linked cell as a reference
Good Luck
Mark Graesse
(e-mail address removed)
Boston M
----- nevoir > wrote: ----
Hi Guys
How do i get a selected option button to set the value of anothe
cell
Many Thanks, ne
