I want to create a user-form with a combo box (CB1) and 2 text boxes (TB1 & TB2). Based on the input for CB1 and TB1, the output will show in TB2.
For CB1, there would be 4 different values:
Private Sub UserForm_Initialize()
CB1.AddItem "Search DB1"
CB1.AddItem "Search DB2"...