Radio Button reference cell issue

[gan_xl]

Hi,

Please see the attached file.
I tried to create a radio button in D16 with reference cell to O16, but when button is inserted it automatically refers to cell O15. If I change it to O16 the buttons in D15 also gets automatically changed to O16. I have been struggling to create radio buttons with respective O reference cells for the remaining rows also. Please help me by indicating what I am doing wrong here.

Thanks in advance.

[Tsjallie]

It's always a fuzz with these controls on worksheet.
Here's a working alternative.
Uses some simple conditional formatting and the worksheet's Selection_Change event (see codemodule of the sheet).

[gan_xl]

Thank you so much. It is 99% perfect.
Could you please help me by changing the code so that it should work only if I click using mouse on the buttons? Currently, the option gets selected even if I use the left or right arrow keyboard button to move over radio buttons. Please help me.

[Tsjallie]

The attached version allows for selecting options only by mouse-click.

To prevent the user from entering the Options Area (F12:J24) with the arrow keys the Options Area is surrounded by "NoGo Areas" (top, left, bottom, right).
When entering (=selecting) a cell in a NoGo Area the cursor will be bounced back.
The header of the Options Area is included in the Top NoGo Area so also these cells cannot be selected.
The row and column sizes of the NoGo Areas are set very small to allow them to be still selected.
They cannot be hidden, becaause cells in hidden rows or columns cannot be selected by the user (only vba can) and so the Selection_Change event would not be triggered.

When an option is selected the cursor is moved to [A1] which is hidden.
Also assigned names to the areas for easier reference.

[gan_xl]

Thank you so much. It works great.