How do I create a simple Sales survey with radio buttons ?

[Guest]

Hi folks,

I want to create a simple Sales survey in Excel. I am hoping to use radio
buttions to get the ratings for my questions since Sales would not agree to
spending too much time. But I do not know how to enter Radio buttion in
Excel. Are you able to help?

 

[Guest]

You'd be hard pressed to find an easier solution than Dave Peterson's at
Debra Dalgleish's website:
http://www.contextures.com/xlform01.html

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Ray C]

Hi Ron,

This seems to help me in one of my projects, but I have a question
concerning Dave Peterson's solution.
How does column C get refreshed when I select an option? If I can find this
out, my problem is solved. I'm looking for something similar to this.

But I can't seem to figure out how column C refreshes by showing the answer
selected once a radio button gets clicked on.

Thanks

 

[Ron Coderre]

Wow! You have a follow-up question TWO years after the original post!

Right-click on any of the option buttons in a row
<Format Control><Control tab>
Cell Link: (this cell holds the value of the option button group.)

I hope that helps

***********
Regards,
Ron

XL2003, WinXP

 

[Ray C]

Hi Ron,

Thanks for your response but when I try right-clicking the radio buttons on
my client's worksheet, the radio button does not get "selected" (i.e gray
rectangle around it). We're using Excel 2002 SP3.

Thanks

 

[Ron Coderre]

You may need to UNprotect the sheet.

***********
Regards,
Ron

XL2003, WinXP

 

[Gord Dibben]

Ray

Sounds like the option buttons are from the Control Toolbox.

Open the Control Toolbox Toolbar and click on the "Design Mode" icon.

Now right-click on the option button.


Gord Dibben MS Excel MVP

 

[Ray C]

I managed to right-click the option button but I don't have the Control tab
available in the Format Control dialog, hence no Cell Link.

How can I test if the control is from the Forms toolbox or the Controls
toolbox?
I should mention that the option buttons are inside a group box. And that
there is one group box on each row of the worksheet. There are about 100 rows.

Thanks!