How to populate a userform combobox from an excel worksheet

jrooney7 · #14 09-16-2018, 07:12 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate Combobox from Excel into a Word UserForm	ferguson4848	Word VBA	3	10-28-2016 09:05 PM
Userform calls other userform, then populate worksheet	Lehoi	Excel Programming	0	02-03-2016 02:58 PM
Using combobox to pass data from an Excel spread sheet to text boxes on userform	Stewie840	Word VBA	14	12-17-2015 10:13 PM
Trying to populate Word bookmarks with excel UserForm	smd1112	Excel Programming	7	09-03-2014 09:42 PM
VB code: populate combobox from columns in Excel file	billybeach	Outlook	2	04-27-2013 04:38 AM