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?