Hi Marwan,
There is a GroupName property of the OptionButton control. Give the same
GroupName to all of the OptionButtons that you want to link to one cell and
a different GroupName to all of the OptionButtons that you want to link to
the other cell.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"marwan hefnawy" wrote in message
...
when using option buttons on the worksheet, I noticed that they are all
linked to the same cell, when I change the cell link in one of them they
are
all changed automaically.
I want to link some option buttons to one cell, and another set of option
buttons (in the same sheet) to another cell in the same sheet.
Is this possible?
Thanks