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?

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


"Manoj" wrote:

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

"Ron Coderre" wrote:

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


"Manoj" wrote:

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?

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" wrote:

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" wrote:

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


"Manoj" wrote:

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,

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" wrote:

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" wrote:

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" wrote:

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


"Manoj" wrote:

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?

You may need to UNprotect the sheet.

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

XL2003, WinXP


"Ray C" wrote:

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" wrote:

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" wrote:

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" wrote:

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


"Manoj" wrote:

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?

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

On Mon, 1 Dec 2008 06:19:01 -0800, Ray C
wrote:

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" wrote:

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" wrote:

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" wrote:

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


"Manoj" wrote:

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?

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!

"Gord Dibben" wrote:

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

On Mon, 1 Dec 2008 06:19:01 -0800, Ray C
wrote:

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" wrote:

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" wrote:

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" wrote:

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


"Manoj" wrote:

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?