Helpmepls
02-23-2013, 10:33 PM
Hi, I have what is probably a basic query, but simply don’t know enoughVBA code to pull this together.
I have an excel sheet with 2 sheets. Sheet1 is called QuestionSetA and Sheet2 is called QuestionSetB. Both sheets have the same structure:
Column A lists thequestion numbers
Column B lists thequestion
Column C lists theanswer
I have also set up a user form. The user form has 2 comboboxes. Combobox 1 has a dropdown list where the user can select QuestionSetA orQuestionSetB.
Combobox2 the allows the user to select the question they want ananswer for.
On the user form I also have a button and 2 text boxes.
What I would like is to be ableto select the desired questionset from combobox1 and the desired questionnumber from combobox 2, click the button and have some code go to which eversheet was selected, identify if the question number and display the questiontext in one text box and the answer in the other textbox. Hoping someone can help me. Many thanks
I have an excel sheet with 2 sheets. Sheet1 is called QuestionSetA and Sheet2 is called QuestionSetB. Both sheets have the same structure:
Column A lists thequestion numbers
Column B lists thequestion
Column C lists theanswer
I have also set up a user form. The user form has 2 comboboxes. Combobox 1 has a dropdown list where the user can select QuestionSetA orQuestionSetB.
Combobox2 the allows the user to select the question they want ananswer for.
On the user form I also have a button and 2 text boxes.
What I would like is to be ableto select the desired questionset from combobox1 and the desired questionnumber from combobox 2, click the button and have some code go to which eversheet was selected, identify if the question number and display the questiontext in one text box and the answer in the other textbox. Hoping someone can help me. Many thanks