Forms, Radio buttons, GroupName value

**penfold1992** · 06-25-2013, 05:59 AM

I have a group of radio buttons and I want some code to work out what has been selected.

I could set up an array and a For i = 1 to x to find the correct one but I was wondering if there was an easier command to find the correct value...

Is there a way to spit out the value that is "True" from a Group Name?

**Norie** · 06-25-2013, 06:30 AM

Why not loop through all the buttons in the group?

**penfold1992** · 06-25-2013, 06:40 AM

I was planning on doing that, but i just wondered if it was a waste of coding if there is just some simple...

Dim x as string

x = Commands.Group("Section").Value

Commands(x).Value

if you can kinda understand what im doing there..., would obviously save space and time

**Norie** · 06-25-2013, 06:46 AM

I don't think there's way to do that.

Mind you it is a bit unclear what you have.

You mention a GroupName, but Forms option buttons don't have such a property.

Do you mean a group box that you've put a set of option buttons in?

If you do then you can set the same Linked cell for all the option buttons in the group box and it will reflect which is chosen.