option buttons

R

Rob Bovey

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 *
 
B

Bob Phillips

Neither forms nor control toolbox buttons do this automatically, or even
link at all on setup AFAIK, it has top be set. And it is just as easy to
change. If forms optionbuttons, right-click the button and select format
control and goto the control tab. If control toolbox. right-click and select
properties.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

marwan hefnawy

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
 
T

Thomas Bartkus

marwan hefnawy said:
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?

Draw a Group Box around each set of option buttons you wish to define. Each
"Group" of option buttons will work independently and each can have it's own
linked cell. Without the Group Box, all option buttons drawn on a worksheet
will be considered part of the same group.

Thomas Bartkus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top