Excel - option button in cell

[Kath]

Hello,

This may be a really simple one but does anyone know how to access the value
of an option button, given the cell reference?

Thank you!

Kath

 

[ag]

Hi Kath,

You could try something like this:

Create your optionbutton, then in the optionbutton_change, type the
following:

Private Sub OptionButton1_Change()
Range("A1").Value = OptionButton1
Range("A2").Value = OptionButton2
End Sub

This will output the values to some cells, you could then maybe hide the
column showing the cells if you didn't want them seen, then you could
reference the cells

Hope this helps

Regards

Andy Gallagher