Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I wan to select a button
I am making a survey for my 8th grade history class. I need to ask a bunch
of questions that will have 5 answers. I want to have them pick one answer and have it stay picked unless they change their mind. I want their choices to remain as they progress down through the survey to the rest of the questions. I can make a option boxes but, when I pick a new question it moves the dot to that box. How do I keep it picked and have the next questions get the dots they need? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I wan to select a button
If you're creating a survey form, you may want to look at Debra Dalgleish's
site: http://contextures.com/xlForm01.html Happy wrote: I am making a survey for my 8th grade history class. I need to ask a bunch of questions that will have 5 answers. I want to have them pick one answer and have it stay picked unless they change their mind. I want their choices to remain as they progress down through the survey to the rest of the questions. I can make a option boxes but, when I pick a new question it moves the dot to that box. How do I keep it picked and have the next questions get the dots they need? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I wan to select a button
You'll need to assign each set of option buttons a "Group Name".
- Right-Click on your first Option Button - Select "Properties" - Once the Properties Window is open, select the other four buttons for that Group (hold down CTRL and click). In the Properties Box, find the Field titled "GroupName" Type in a name, such as Group1 Select your next 5 option buttons (unselecting the first 5) Assign them a name, such as Group2 etc..... HTH Elkar "Happy" wrote: I am making a survey for my 8th grade history class. I need to ask a bunch of questions that will have 5 answers. I want to have them pick one answer and have it stay picked unless they change their mind. I want their choices to remain as they progress down through the survey to the rest of the questions. I can make a option boxes but, when I pick a new question it moves the dot to that box. How do I keep it picked and have the next questions get the dots they need? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I wan to select a button
ps.
If you use optionbuttons from the Forms toolbar, put a groupbox (also on that same toolbar) around the optionbuttons. And then rightclick on an optionbutton on that group, choose Format Control|control tab. Then assign the linked cell. If you use optionbuttons from the control toolbox toolbar, rightclick on each of the members of the group, choose properties, and give that group a unique groupname. You can assign the Linkedcell on that properties window. Dave Peterson wrote: If you're creating a survey form, you may want to look at Debra Dalgleish's site: http://contextures.com/xlForm01.html Happy wrote: I am making a survey for my 8th grade history class. I need to ask a bunch of questions that will have 5 answers. I want to have them pick one answer and have it stay picked unless they change their mind. I want their choices to remain as they progress down through the survey to the rest of the questions. I can make a option boxes but, when I pick a new question it moves the dot to that box. How do I keep it picked and have the next questions get the dots they need? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill button is not appearing when I select cells in Excel 2007 | Excel Worksheet Functions | |||
Select Option button unhide row | Excel Discussion (Misc queries) | |||
I cannot select the compare and merge button | Excel Worksheet Functions | |||
Excel 2003 is missing toolbar button select visible cells | Excel Worksheet Functions | |||
XLS Worksheet 'Select All' button + top 2 rows not in view in wind | Excel Discussion (Misc queries) |