Form Control, Option Buttons

[Dannyb78]

Firstly my apologies as I know this has been asked before but I still cannot get it to work.

I'm using option buttons from the Form Control menu, the ActiveX Control menu is ghosted, as is the design toolbox button. I have no idea how to un-ghost them.

No matter how I group and re-name and set the linked cell all buttons are linked. I've tried a grouping box, I've tried editing each button individually. I just need two groups, three buttons linking to one cell, nine buttons linking to another. I'm absolutely pulling my hair out and I swear I'm not as much of an excel beginner as this makes me sound!

 

[Dryver14]

Found this on Microsoft site, not sure if it helps.

[FONT=&quot]Active x are add-ons they are specific to IE version, it could be that the version of ActiveX for IE 10 or IE 11 are not compatible with IE 5.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I would suggest you to follow the steps provided in the following article and see if it helps.[/FONT]
[FONT=&quot]A Web page that contains a custom ActiveX control may not load as expected in Internet Explorer due to defense in depth changes introduced in cumulative security update 896688 (MS05-052)[/FONT]
[FONT=&quot]http://support.microsoft.com/kb/909738[/FONT]

 

[Kyle123]

All the option buttons should be in a group box. So you should have 2 group boxes, one with 3 option buttons in and one with 9 in.

Once you've done this, enter design mode and for each group box, select all the option buttons (whilst holding Ctrl), right click and set the cell link.

You'll then have 2 cells with inputs from the group boxes.

 

[Dannyb78]

All the option buttons should be in a group box. So you should have 2 group boxes, one with 3 option buttons in and one with 9 in.

Once you've done this, enter design mode and for each group box, select all the option buttons (whilst holding Ctrl), right click and set the cell link.

You'll then have 2 cells with inputs from the group boxes.

Many thanks, this worked to an extent. I now have them returning values in two different cells (although I swear I tried this before and it ignored me) I don't really want to use activex as it has to work on many different computers eventually.

Now however the box with 3 has messed up. I select option 1 and it automatically selects option 3 as well, option 2 clears the other two and is selected on it's own. What did I do wrong now??

 

[Dannyb78]

Also, can I hide the grouping box? it looks messy!