How to populate a userform combobox from an excel worksheet

macropod · #1 09-10-2018, 02:45 PM

Have you included the function that fills the list of combo box with the columns from the worksheet/range? I can't see any indication of that from your previous posts. It's in the last code box on that page. It pays to read the entire article...

jrooney7 · #2 09-10-2018, 03:50 PM

Quote:

Originally Posted by macropod

Have you included the function that fills the list of combo box with the columns from the worksheet/range? I can't see any indication of that from your previous posts. It's in the last code box on that page. It pays to read the entire article...

As I stated, I have read that article, and tried multiple times, but I don't know WHERE to insert that function code. I came here looking for help and could do without the snark.

macropod · #3 09-10-2018, 10:26 PM

Quote:

Originally Posted by jrooney7

As I stated, I have read that article, and tried multiple times, but I don't know WHERE to insert that function code.

The article says clearly enough:

Quote:

Copy it to a new vba module and call it from the userform initialisation or from the macro that calls the userform with a command line similar to the following.

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