Excel VBA Option Buttons

  daba 22:00 03 Jul 07
Locked

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 07

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 07

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 07

Oh for an Edit button...

  daba 23:22 03 Jul 07

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.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…