List boxes or not - Help needed re an excel based Questionnaire

Portia2004

New Member
Joined
Feb 28, 2006
Messages
18
Hi All

My VBA skills are so so but I have been tasked with pulling together a questionnaire based tool. I was considering using userforms to contain the question, question assistance and the answers to select from which vary across questions. Examples of the questions are below. The selected answers will need to be placed in a worksheet. I have considered entering a list box onto the user forms but I am struggling with the variety of answers. Has anyone done something like this before or have any suggestions as to the best way to go about this. Any advice would be appreciated. Many thanks




B-06. Will this use any new technology?

Yes, new to industry†
Yes, new to company†
Yes, new to site†
No

B-07. Please describe the technology?

All new process†
Substantially new process†
Major process modification†
Minor process modification†
New integration† of proven process steps

B-08. Which of the following does the scope install, replace, and/or modify/reuse†? (Check all that apply.)
Install Replace Modify/Reuse Not Applicable
Controls and/or instrumentation
Electrical wiring/cables
Piping that conveys
Solids
Liquids
Gases



B-09. Check the descriptions that most closely describe the type of process (if any) that is directly installed or modified by the project. (Check all that apply.)

Manufacturing process producing a continuous product in bulk form†: Solid
Manufacturing process producing a continuous product in bulk form†: Liquid
Manufacturing process producing a continuous product in bulk form†: Gas
Manufacturing process producing a discretely packaged product or assembly†
Manufacturing process producing rolls, sheets, or fibers
Manufacturing process producing a cast, molded, or extruded product
Plant utilities and services†
Plant distribution, conveyance, or storage system†
Waste or emissions discharge†
No process† is directly modified by the project

B-10. Are the trade-offs† among cost, schedule, and operability clearly understood by all team members?

Yes
No

B-11. Please rank the following project priorities in the order of importance†.
1 = Most important driver
2 = Second most important driver
3 = Least important driver

Cost
Schedule
Operability†
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Because you have questions that have "click all that apply" I would use Option buttons. or maybe option buttons mixed with comboboxes.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top