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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
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
 
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
 
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!
 
Back
Top