Thread: Control Cell Link for Option Button based on value in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
arunjoshi[_13_] arunjoshi[_13_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote