View Single Post
 
Old 04-13-2017, 11:06 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Quote:
You might try searching for POPULATE COMBOBOX WITH ARRAY and see what that turns up. Not certain if it can be done
@ Logit
Certainly can, here's the goto page I have bookmarked.

@ thovdael
Have a look at this.
The first combo is populated from column A at the time of Userform_Initialization.
The second and third combos are populated by filtering based on the selections in the combos.
Hopefully this does what you're after and is commented enough that you can follow and adapt to your project.
Attached Files
File Type: xlsm example_thovdael.xlsm (322.9 KB, 22 views)
Reply With Quote