Radio Buttons on Forms VBA

[TMHill]

Hi

I am adding several groups of radio buttons to a form (a page of multiple choice questions) at run-time. Each group has 3 radio buttons in it.

The complication is that there is a 'default' answer for each question, and that button should be selected initially.

So:
I add a new control with a unique name 'ButtonA1'. I then add this to groupname 'OptionButtonGroup1''
Next, I add another control with name 'ButtonB1' and set its groupname property to 'OptionButtonGroup1''
Same with 'ButtonC1', then I move on to question group 2.

I set the controlsource property of each button to an independent cell (a 3 column list of TRUE/FALSE, where only one of the three columns is set to TRUE - this is the default value I am picking up)


Everything in this process is working fine - but there is one behaviour which I am getting which is driving me NUTS! The first time I select a different answer to the default, Excel sets all values of that group to FALSE and the buttons go empty.

Plus, it doesn't matter which group I choose to click first, I get the same behaviour. Then on the next click, everything works fine! And from that point on every other group is also fine.

Anybody got any ideas or seen/solved this before?

 

[TMHill]

Quick update to this - there is occassionally another weird behaviour which I believe is a symptom of the same cause (whatever that is!):

If the default is option 2, then when I click option button 1, the selection changes to option button 3. When this happens, it repeats with every group. Once its happened once, it won't happen again within that group.

I'm pretty sure its got something to do with what it thinks is its starting value - but i've even made it read that off the sheet and specifically set it, and I can't think of what else to do with it!

 

[asoulsby]

I had the same problem and found that adding:

Application.Calculation = xlManual

before loading or showing the user form solved it - you would then need to turn calcululations back on afterwards.