Ok, I figured out my error on the text box label issue, but now I'm having an issue with the 2nd combo box. First combo Box works fine, but no drop down list is showing up on the 2nd combo box. I am attaching the sheet. You can go through a dummy trial of adding a complaint and see how it happens.
Here is the code:
Private Sub UserForm_Initialize() 'List of 35 stores on the "Stores" worksheet
For i = 1 To 35
ComboBox_Country.AddItem Sheets("Stores").Cells(i, 1)
Next
End Sub
Private Sub OptionButton4_Click()
End Sub
Private Sub UserForm1_Initialize() 'List of Type of Complaints on the "Type" worksheet
For i = 1 To 6
ComboBox_Country1.AddItem Sheets("Type").Cells(i, 1)
Next
End Sub
Bookmarks