jereece
October 25th, 1999, 02:22 PM
I am building a simple training assessment tool using Excel 97. Users will read a question in cell 1A for example, answer YES or NO in cell 1B and then, based on their answer, will be given
details in cell 1C of what training they need to perform that function. I can easily
do this using the IF function in Excel, but I would like to have a dropdown combo box for Cell 1B with the options Select, Yes, No) so users would be forced to select an answer. Then upon
selecting an answer, the script would run the IF statement to output the training answer in cell 1C.
I am sure this is quite simple to a programmer and unfortunately I am just
beginning to learn a little about VBA.
I appreciate any help you can give.
Jim Reece
details in cell 1C of what training they need to perform that function. I can easily
do this using the IF function in Excel, but I would like to have a dropdown combo box for Cell 1B with the options Select, Yes, No) so users would be forced to select an answer. Then upon
selecting an answer, the script would run the IF statement to output the training answer in cell 1C.
I am sure this is quite simple to a programmer and unfortunately I am just
beginning to learn a little about VBA.
I appreciate any help you can give.
Jim Reece