Check box form - setup of various options

Been trying to work out what I need and I think its a check box window form, but feel free to correct me.
Looking for help in setting up a form with three check box options on the left - only one of which can be selected at a time.
Then two options on the right - again only one of the two can be selected.
Once the options on both sides have been selected, a button becomes live which should link to and run one of six macros.

I have setup the Form with the check boxes and button, but am struggling to move to the next stage.

Thanks for any help

For the functionality you describe, you'll need option boxes in two fames, three in the first, two in the 2nd.

Hi
This an example might helps

Cleaner demo - there is no need for the clutter of placing option buttons in frames to segregate them.
Use the 'group' function in the 'optionbox' properties window.
torachan.

Thanks for your help so far.
Mohadin - This works and obviously just need to replace the message box with a run macro, but it allows me to select multiple options on both sets 1-3 and 4-5. Is there a way to deselect 1, 2 or 3 if I click one of the other options - and the same for 4 and 5 (selected 4, but changed mind so select 5 and 4 deselects itself?

Please Login or Register  to view this content.

New file - remove message boxes and remove apostrophe in front of macro calls
torachan

Thanks torachan

Can still select more than one option, but also can't get macros to run using Call ?

Any ideas what I'm missing?

without actual file difficult to say - where do your macros reside ?

Will try and upload a file in a bit, but macros are all kept in same file.
As I say it didn't seem to like the Call instruction, but I guess that could also be the actual macro name - will have a play around.
Any thoughts on being able to select multiple options?
Thanks for your time, much appreciated.

Think I'm getting there, but getting 'Else without If' error on the following:

Please Login or Register  to view this content.

In this case you will need only one end if

Please Login or Register  to view this content.

@Chanty, I have to ask the question, Why?
If you are merely wanting shortcuts to your macros, why not just assign each to a command button.
You can not run macros simultaneously so no much point in been able to multi-select.
I have applied the 'KISS' principle to the attached file.
torachan.

Thanks torachan

Much simpler option and solves the issues that I was creating!

Thanks for all your time - much appreciated.

I did want to get the other option to work, as there was a third group that I wanted to add at a later date, but have shelved that for now.

Thanks again to all.