Excel VBA Option Buttons

  daba 22:00 03 Jul 2007

Should be a simple one - but I can't find the answer.

Is it possible to put more than 1 "group" of Option (Radio) Buttons on the same worksheet ??

At the moment I have two sets of two buttons each, separately "grouped", but they interact between the groups. Is it possible to separate the Options Controls ?

I'm not using a vba "form" as such, just some simple VBA controls on the sheet.

  daba 22:09 03 Jul 2007

OK - sorted.

One of the Properties (yes, I missed it) is "Group Name"

Changed that for the other two option buttons and that has "unlinked" them.

Obvious when you know how....

  VoG II 22:11 03 Jul 2007

If you mean that you have say 2 groups of controls and you want to disable selection of a button in Group 1 if another button is already selected in Group 2 then I don't think that this is possible without some code.

I am very willing to be proved wrong.

  VoG II 22:17 03 Jul 2007

Oh for an Edit button...

  daba 23:22 03 Jul 2007

Not quite what I had in mind VoG.

Just two sets of mutually exclusive options, where one option is always selected from each group - simple example:-

Group 1 : Colour : Red, Blue, Black, White.

Group 2 : Shape : Round, Square, Triangle.

Anyway, giving each group a unique groupname (looks like they can be called anything) in the properties seems to do the job nicely.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?