Excel Functions-Forms

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I'm trying to create a form in Excel which asks the user a
series of questions and the answers are scale based (i.e.
on a rating level of 1 - 5). There are approximately 40
questions and in it's current status if the value for
question one is selected when answering question 2 and on
the previous selection is automatically cleared. What
have I done incorrectly and how do I fix it?

Regards and thanks
 
Rich,

Show us the code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Sorry, I may not have explained it all too well. I'm
using Radio Buttons for the rating scale. Here's an
example of the questions within the spreadsheet...e.g. if
I select 4 which equals "Satisfied" in question one; when
I answer the next question, my previous selection clears.
Hope this makes sense.

Thanks,


Do you receive the information you need in a format that
is easy to understand?

1 2 3 4 5

Unsatisfactory Very Satisfied



Is the information you need to access easy to locate?


1 2 3 4 5

Unsatisfactory Very Satisfied
 
Rich,

I would think that that is because all of your radio buttons are in the same
group, rather than separate groups per question. Only one radio button per
group can be active at any one time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Got it worked out. THANKS!
-----Original Message-----
Rich,

I would think that that is because all of your radio buttons are in the same
group, rather than separate groups per question. Only one radio button per
group can be active at any one time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Back
Top