View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
furbiuzzu furbiuzzu is offline
external usenet poster
 
Posts: 57
Default 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.