#1   Report Post  
Fable
 
Posts: n/a
Default Option Button


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

  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does Option Button not hold transparent property? ARB Excel Discussion (Misc queries) 1 August 2nd 05 07:47 PM
selecting more than one option button Katie-Baughman Excel Discussion (Misc queries) 4 May 6th 05 03:24 PM
How to protect option button? Julie Excel Worksheet Functions 1 March 23rd 05 04:42 AM
Second option button disappears when I make another column Monique Excel Worksheet Functions 0 March 9th 05 10:57 PM
Option Button on Forms Toolbar admannj Excel Discussion (Misc queries) 4 January 25th 05 02:07 AM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"