View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
D. Jones D. Jones is offline
external usenet poster
 
Posts: 8
Default Using Option Buttons from the "Forms" Menu

Thankd you for your response but that is not the issue -- I want to have two
lists on the same sheet with option button selection. I can only get teh
option buttons to work from one linked cell -- I need to be abl to link a
second set of buttons to a different linked cell form the first group of
buttons.

"Chip Pearson" wrote:

Right click the control and choose "Format Control". There, click the
"Control" tab and set the "Cell Link" property to the cell to which that
control's value should be linked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"D Jones" wrote in message
...
I am tyring to set up two different "option buttons" (radio button) lists
on
the same worksheet.

Evertime I add a "option button" it shares the same linked cell as the
option buttons I have already placed on the sheet.

How do I assign different link cells to two different sets of "option
buttons" on the same wooksheet?

I really appreciate you help

Thanks,