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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
