• Hot Topics

Excel Concatenation depending on ComboBox-Value

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.

This thread is current as of March 17, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel