Userform with cascade ComboBox

NoSparks · #5 04-13-2017, 11:06 PM

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.

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
Cannot tile or cascade presentations in PP2013	dave3point0	PowerPoint	0	01-07-2016 03:20 AM
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
Value of Combobox in other userform	Vibov	Excel Programming	4	11-19-2015 04:12 AM
Create UserForm ComboBox or ContentControl	ptmuldoon	Word VBA	11	01-17-2015 05:58 PM