Hey guys, I have this project I?m currently working on and would need some advice on how to implement a certain concatenation. So I have a UserForm (frml_1) which serves as an input mask for the user. The user can choose options based on 4 ComboBoxes on this UserForm: ComboBox cb_Workers to choose a worker ==> data in worksheet ?Workers? ComboBox cb_Case to choose a case ==> data in worksheet ?Cases? ComboBox cb_Class to choose a class ==> data in worksheets ?MR1 to MR5? ComboBox cb_Index to choose an index ==> data in worksheet ?Cases? All these selections are written to a worksheet called ?Summary? in order to display the choices the user made. Now my second UserForm (frml_Test1) activates after all choices have been made and the Accept Button on UserForm frml_1 has been clicked. It serves as a Questionnaire. There are different questions on different worksheets (?Questions1-6?) and depending on the cb_Case- value selected previously, the questions are different. This all works fine (thanks again to bertie who helped me a lot!). Now what I would need to realize is the following: The first two questions, which are used for this Questionnaire, need to be concatenated with the value of the class, which has been chosen previously on UserForm frml_1. For example the user makes the following selections: Worker 1 = Firstname1, Surname 1 (the workers category is displayed in the ?category?- TextBox, which is MR1) Case ?New? Class ?1? Index doesn?t matter, but let?s take ?Standard? Now that case "New" has been chosen, the UserForm frml_Test1 will use the Questions from the worksheet "Question1" for the Questionnaire. Because "class 1" has been chosen,
This question generated 21 answers. To proceed to the answers, click here.