Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms in Excel
I created a multiple choice final with 20 questions having 4 answers with
radials. If the student clicks number 1 in question 1 and then clicks number 2 in question 2 the radial in number 1 clears! How do I make sure each set of answers for the 20 question react independently of the others? I have to post this (it is an on-line calss so no hope in "hand outs") by Monday, please help, the whole thing is useless this way. As a last resort can I simply "turn off" this automation? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms in Excel
Does on-line mean excel?
If your optionbuttons are from the Forms toolbar, the put all 4 optionbuttons in each group in a groupbox (also on that Forms toolbar). If your optionbuttons are from the Control Toolbox toolbar, then rightclick on each optionbutton show the properties (you'll have to be in design mode for this). Each group should have its own unique groupname. If you're creating a survey form, you may want to look at Debra Dalgleish's site: http://contextures.com/xlForm01.html Mary jane wrote: I created a multiple choice final with 20 questions having 4 answers with radials. If the student clicks number 1 in question 1 and then clicks number 2 in question 2 the radial in number 1 clears! How do I make sure each set of answers for the 20 question react independently of the others? I have to post this (it is an on-line calss so no hope in "hand outs") by Monday, please help, the whole thing is useless this way. As a last resort can I simply "turn off" this automation? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms in Excel
Not an on-line excel class, a business class. Thanks, I'll try this, I tried
putting all four in one "shape" so I was close. Thanks again. "Dave Peterson" wrote: Does on-line mean excel? If your optionbuttons are from the Forms toolbar, the put all 4 optionbuttons in each group in a groupbox (also on that Forms toolbar). If your optionbuttons are from the Control Toolbox toolbar, then rightclick on each optionbutton show the properties (you'll have to be in design mode for this). Each group should have its own unique groupname. If you're creating a survey form, you may want to look at Debra Dalgleish's site: http://contextures.com/xlForm01.html Mary jane wrote: I created a multiple choice final with 20 questions having 4 answers with radials. If the student clicks number 1 in question 1 and then clicks number 2 in question 2 the radial in number 1 clears! How do I make sure each set of answers for the 20 question react independently of the others? I have to post this (it is an on-line calss so no hope in "hand outs") by Monday, please help, the whole thing is useless this way. As a last resort can I simply "turn off" this automation? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms in Excel
Group Box did not work however the second set of instructions using group
names worked fine, a little cumbersome but all is well that ends well. Thanks! "Mary jane" wrote: Not an on-line excel class, a business class. Thanks, I'll try this, I tried putting all four in one "shape" so I was close. Thanks again. "Dave Peterson" wrote: Does on-line mean excel? If your optionbuttons are from the Forms toolbar, the put all 4 optionbuttons in each group in a groupbox (also on that Forms toolbar). If your optionbuttons are from the Control Toolbox toolbar, then rightclick on each optionbutton show the properties (you'll have to be in design mode for this). Each group should have its own unique groupname. If you're creating a survey form, you may want to look at Debra Dalgleish's site: http://contextures.com/xlForm01.html Mary jane wrote: I created a multiple choice final with 20 questions having 4 answers with radials. If the student clicks number 1 in question 1 and then clicks number 2 in question 2 the radial in number 1 clears! How do I make sure each set of answers for the 20 question react independently of the others? I have to post this (it is an on-line calss so no hope in "hand outs") by Monday, please help, the whole thing is useless this way. As a last resort can I simply "turn off" this automation? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms in Excel
There's a difference bstween the optionbuttons from the Forms toolbar and the
optionbuttons from the Control Toolbox toolbar. If you looked at the file on Debra Dalgleish's site, you'll see that used the optionbuttons from the Forms toolbar. In general, I like them better. They behave nicer, but have a lot few properties to customize. Mary jane wrote: Group Box did not work however the second set of instructions using group names worked fine, a little cumbersome but all is well that ends well. Thanks! "Mary jane" wrote: Not an on-line excel class, a business class. Thanks, I'll try this, I tried putting all four in one "shape" so I was close. Thanks again. "Dave Peterson" wrote: Does on-line mean excel? If your optionbuttons are from the Forms toolbar, the put all 4 optionbuttons in each group in a groupbox (also on that Forms toolbar). If your optionbuttons are from the Control Toolbox toolbar, then rightclick on each optionbutton show the properties (you'll have to be in design mode for this). Each group should have its own unique groupname. If you're creating a survey form, you may want to look at Debra Dalgleish's site: http://contextures.com/xlForm01.html Mary jane wrote: I created a multiple choice final with 20 questions having 4 answers with radials. If the student clicks number 1 in question 1 and then clicks number 2 in question 2 the radial in number 1 clears! How do I make sure each set of answers for the 20 question react independently of the others? I have to post this (it is an on-line calss so no hope in "hand outs") by Monday, please help, the whole thing is useless this way. As a last resort can I simply "turn off" this automation? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Forms | Excel Discussion (Misc queries) | |||
forms in Excel | Excel Discussion (Misc queries) | |||
Forms in Excel | Excel Discussion (Misc queries) | |||
forms in excel | Excel Worksheet Functions | |||
forms in Excel | Excel Discussion (Misc queries) |