how do i populate a cell by clicking it in excel

  • Thread starter Thread starter radio button
  • Start date Start date
R

radio button

I am trying to create a radio buton in excel so that when it is clicked it
will put a value in the cell next to it. Anyone have any ideas?
 
Button are objects that sit ontop of the wroksheet and don't have cell
locations like row or column. they do have a property LinkedCells which will
display True or False when selected or not selected. You can make the liked
cell a column that is not visible on the worksheet like column IV. then put
a formula in a cell next to the button that uses and if statment like this

=if(IV7="True","display abc","")
 
hi
radio buttons (option buttons) work in groups of two or more. they allow you
to select one option out of two or more but not more than one. this is
controled by the group property of the option button (radio button).
if you have only one option button per deciision (cell) then you are not
using the option button correctly. i would suggest check boxes instead.
check boxes reprensent a true true/false relations in one control as opposed
to needing two or more options buttons (radio buttons) to represent the same
thing.
read up on check boxes and options buttons.

regards
FSt1
 
Back
Top