How to assign different Linked cells to option buttons
Hi all,
My problem is to create more than 200 Option buttons linked to
different cells
i.e
optionbutton1.linkedcell="A1"
optionbutton2.linkedcell="A2"
.......
........
optionbutton200.linkedcell="A200"
After i've created all optionbuttons, i noticed they all have the same
linked cell
how can i assign them the right linked cell through a macro??
The problem is i have to know which line of my table has been selected
through the related option button....
thanks in advance for your help.
|