Hi,

I am having problems with some radio buttons on my spreadsheet. i have
created a quetionnaire and have different questions with a set of 5 radio
buttons each but i am finding that in 1 question when a radio button is
clicked its fine but when i move on to the next question and click the radio
button, the radio button selected for the above question comes off! its like
they are working together and one cancels out the other!! how can i do it so
the radio button remains clicked regardless of what answer i click on?

please reply as your earliest possible convinience.

thanks

Hi Gemz

For each question you need to add a Group box that then contains your
radio buttons for the respective question. The group box isolates the
action of the radio buttons to just that question.

Hope this helps.



Gemz wrote:
Hi,

I am having problems with some radio buttons on my spreadsheet. i have
created a quetionnaire and have different questions with a set of 5 radio
buttons each but i am finding that in 1 question when a radio button is
clicked its fine but when i move on to the next question and click the radio
button, the radio button selected for the above question comes off! its like
they are working together and one cancels out the other!! how can i do it so
the radio button remains clicked regardless of what answer i click on?

please reply as your earliest possible convinience.

thanks

Hi,

This is getting abit annoying now - all morning i was trying to figure out
how i can get the radio buttons to stop cancelling eachother out.. and now
somehow they have just started to work again!! even without this 'group box'.
So maybe its only going to work sometimes hence an episode this morning with
it not working so i will just do the group box anyways but how? is its just a
normal border i do around the radio buttons (to create a box)? or is there
something called group box? i select all and look for the 'group' option but
cant see one. i have used active x control to create the buttons.

thanks in advance.

"Dav" wrote:

Hi Gemz

For each question you need to add a Group box that then contains your
radio buttons for the respective question. The group box isolates the
action of the radio buttons to just that question.

Hope this helps.



Gemz wrote:
Hi,

I am having problems with some radio buttons on my spreadsheet. i have
created a quetionnaire and have different questions with a set of 5 radio
buttons each but i am finding that in 1 question when a radio button is
clicked its fine but when i move on to the next question and click the radio
button, the radio button selected for the above question comes off! its like
they are working together and one cancels out the other!! how can i do it so
the radio button remains clicked regardless of what answer i click on?

please reply as your earliest possible convinience.

thanks