UserForm Multi ListBox Setup

[Emoncada]

I need some direction on how to set this up

The 1st listbox has Types of Hardware.

I want to then populate the 2nd Listbox with Models based on 1st List Box selection. I can possibly create a Name Range to get that list populated based on 1st Listbox.

My biggest issue is how do i then populate the 3rd List Box based on first 2 listbox selections, then populate a textbox with questions based on those selections.

Basically, I just need best possible way to get this setup.

Any help would be appreciated.

Thanks,

 

[ranman256]

i go with the 2 listbox dbl-click method.
1st list filters the 2nd list.
dbl-clicking the 2nd list adds it to the 3rd box (picked list)

the AFTERUPDATE event of list1 runs code to refill list2 based on list1

(the manage attachements link is gone!)