Option Buttons

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am trying to create a yes/no facility using 2 option
buttons in one cell, when I then replicate the same
option in the next cell down they link creating 4 options
over 2 lines and so on through the entire sheet.

Can these be separated into individual local cell yes/no
options that are not effected by other such instances

Any help much appreciated
 
If you're using optionbuttons from the Forms toolbar, then put each group in a
groupbox.

If you're using optionbuttons from the controltoolbox toolbar, then give each
group a nice groupname. (rightclick|properties). The groupname defaults to the
worksheet name, so they're all grouped together.

But couldn't you make your life a little easier and use checkboxes. Check it to
mean Yes, leave it unchecked and it means No.
 
Back
Top