Control Cell Link for Option Button based on value in a cell
 

I have two option buttons on a sheet. In cell A1, on the same sheet
there is a value which can be either 1 or 2.

Can you help me achieve this? ...

If the value in cell A1 is 1, then the Control Cell Link for the tw
option buttons should become cell B1.

If the value in cell A1 is 2, then the Control Cell Link for the tw
option buttons should become cell B2

--
Message posted from http://www.ExcelForum.com