Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does Option Button not hold transparent property? | Excel Discussion (Misc queries) | |||
selecting more than one option button | Excel Discussion (Misc queries) | |||
How to protect option button? | Excel Worksheet Functions | |||
Second option button disappears when I make another column | Excel Worksheet Functions | |||
Option Button on Forms Toolbar | Excel Discussion (Misc queries) |