Quizzes & Puzzles0 min ago
Documents with multiple choice fields
4 Answers
I work for a not for profit organisation and we are trying to devise a means of creating a CV for a school leaver looking for a job by the user selecting choices from drop down menus, ie we would have all the local schools and colleges available to choose from in the Education section and the means of choosing subjects and grades to list. It's especially for students with disabilities. Can anyone tell me how to make this happen with Microsoft Office products or point me in the right direction please?
Answers
1 to 4 of 4
Best Answer
No best answer has yet been selected by woodpam. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
You could do something simple in Excel.
Here's how to create drop-down lists.
Open a new Work book.
In the first cell of a column type in a heading such as 'School Name'.
Click the cell directly below this and then go to the toolbar at the top and select data....validation.
From the box that appears select the settings tab and for the validation criteria select list.
In the source box type in School A, School B, School C etc.
Click O.K.
Now when you click on that cell you will be given a drop down list of the schools you have entered. You can click on the corner of the cell and drag it down across all of the cells below and it will auto fill the with the list.
Alternatively you could do something similar like this.
Open a new Work book.
Ensure that you have the formula toolbar showing - view....toolbars....formula.
On the second worksheet create your list of schools like this: School A in Cell A1, School B in Cell A2, School C in Cell A3 etc.
Select all of the cells. At the left end of the formula tool bar is a box called the name box. Type a name for you range of cells in here.
On the first worksheet, in the first cell of a column type in a heading such as 'School Name'.
Click the cell directly below this and then go to the toolbar at the top and select data....validation.
From the box that appears select the settings tab and for the validation criteria select list.
In the source box type = 'the name of your range'
Click O.K.
Now when you click on that cell you will be given a drop down list of the schools you have entered on the second worksheet.
You can click on the corner of the cell and drag it down across all of the cells below and it will auto fill the with the list.
You can created all of you other drop down lists in the same way.
Here's how to create drop-down lists.
Open a new Work book.
In the first cell of a column type in a heading such as 'School Name'.
Click the cell directly below this and then go to the toolbar at the top and select data....validation.
From the box that appears select the settings tab and for the validation criteria select list.
In the source box type in School A, School B, School C etc.
Click O.K.
Now when you click on that cell you will be given a drop down list of the schools you have entered. You can click on the corner of the cell and drag it down across all of the cells below and it will auto fill the with the list.
Alternatively you could do something similar like this.
Open a new Work book.
Ensure that you have the formula toolbar showing - view....toolbars....formula.
On the second worksheet create your list of schools like this: School A in Cell A1, School B in Cell A2, School C in Cell A3 etc.
Select all of the cells. At the left end of the formula tool bar is a box called the name box. Type a name for you range of cells in here.
On the first worksheet, in the first cell of a column type in a heading such as 'School Name'.
Click the cell directly below this and then go to the toolbar at the top and select data....validation.
From the box that appears select the settings tab and for the validation criteria select list.
In the source box type = 'the name of your range'
Click O.K.
Now when you click on that cell you will be given a drop down list of the schools you have entered on the second worksheet.
You can click on the corner of the cell and drag it down across all of the cells below and it will auto fill the with the list.
You can created all of you other drop down lists in the same way.
alternative B write a webpage which asks for the questions with drop down lists, the page would generate a report, file, printout (whatever) on hitting OK (or alternatively you could have all options as buttons!), with the choices implemented. Could be written in Javascript or VBScript - neither of these are rocket science and can be picked up using a "dummies guide to..." or get a 14 year old computer-holic to write one for you. honestly they take 5 minutes to write and my son could do it. In fact if you send a spec. i'm sure he'd do it for something to do other than play comp. games for a change, he's always writing websites for a laugh
1 to 4 of 4
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.