Greetings

I’m trying to create a “survey form” with option button for example

POOR FAIR GOOD
1) How was the service? [ ] [ ]
[ ]
2) How was the cleanliness? [ ] [ ]
[ ]
etc….

My problem is every time I place a new row of questions and you select
an option of the new question, the prior question option disappears
(since you only can have one hi-lited
apparently). If there is any way to avoid this? So each row can have
its own rating?

Im trying to avoid “X” and “Yes and No” in the cells since the option
button look more professional.

Thanking you in advance


--
Fable


------------------------------------------------------------------------
Fable's Profile: http://www.excelforum.com/member.php...fo&userid=2185
View this thread: http://www.excelforum.com/showthread...hreadid=395969

Fable,

You had me going when you said they disappeared. I think you mean when you
click an option button in the second row, the selected one in the first row
is no longer selected. That's the way they work. Only one per group.
Radio buttons. If you're using option buttons from the Forms Toolbar, put a
group box around each row's buttons. That will put them in separate groups.
If you're using option buttons from the Controls Toolbox, go to properties,
and set the group name (any name) to the same name for each row.
--
Earl Kiosterud
www.smokeylake.com

"Fable" wrote in
message ...

Greetings

I’m trying to create a “survey form” with option button for example

POOR FAIR GOOD
1) How was the service? [ ] [ ]
[ ]
2) How was the cleanliness? [ ] [ ]
[ ]
etc….

My problem is every time I place a new row of questions and you select
an option of the new question, the prior question option disappears
(since you only can have one hi-lited
apparently). If there is any way to avoid this? So each row can have
its own rating?

Im trying to avoid “X” and “Yes and No” in the cells since the option
button look more professional.

Thanking you in advance


--
Fable


------------------------------------------------------------------------
Fable's Profile:
http://www.excelforum.com/member.php...fo&userid=2185
View this thread: http://www.excelforum.com/showthread...hreadid=395969