Option Button

[shusters]

I need to have an activated radio button place a value of 1 either in the same cell or other cell. I am not familiar with VB although I can cut and paste with the best of them

[Cheeky Charlie]

If you create the option button via the forms toolbar (which I'd strongly recommend) then you simply need to right click it, format control..., set a 'cell link'

If you create the option button via the control toolbox (which I would recommend against) then you need to enter design mode (click the set square/ruler/pencil button) right-click and view the properties and set the cell link - you need to exit design mode in order to make it work.

NB neither type of radio button allows 'click to unselect' (although it could be written in a macro for the activex control version) - I presume you will have options of which one must be selected, so this shouldn't be a problem, selecting another radio button will unselect the first.

CC