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†
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†
