With the comboboxes populating correctly from my excel worksheet, I am now running into a different issue. I posted this on another thread, and I'm sorry for the redundancy, but now I'm wondering if it may be related to or interrupted by this excel population code.
I have a userform with multiple textboxes and comboboxes. I have set some to be hidden in the userform initialize event, and then want them to become visible if certain selections are made in the userform comboboxes. So if the user selects "Other/Multiple" from this dropdown, which has been populated from the excel file, a corresponding textbox should appear. But nothing is happening. The example below is from the same userform in Excel, and it works there, but it is not working in Word. Any thoughts?
Code:
Private Sub SafetiesComboBox_Change()
Select Case SafetiesComboBox.Value
Case "Other/Multiple"
FirearmPreFireUserForm.SafetiesTextBox.Visible = True
Case Else
FirearmPreFireUserForm.SafetiesTextBox.Visible = False
End Select
End Sub