Creating a Range of a Listbox based on the Selection Made in Another ListBox

**masood78** · 05-01-2014, 02:13 AM

I have two lists mainly TV Brand & There Models.

List 1 (TV Brand)
Sony
LG
Samsung

Depended List 2 (Models)
Sony LG Samsung
EX420 55EB9600 PL43E450A1FXZP
EX430 77EC9800 PL43E490B4FXZP
EX550 55EA8800 PL43E400U1FXZP
EX520 KN55S9C UN32EH5300FXZP
EX645 55EA9800 PL64E8000GFXZP

I'm using two Listboxes (Form Control) with multiple selection options namely Listbox 1 (Brand) & Listbox 2 (Models). I want listbox 2 input range to be depended on selection made on Listbox 1 (Brand). For example, if user selects Sony then box2 should show only Sony's models and if user selects Sony & LG, box2 should show models for both Sony & LG.

**Pauleyb** · 05-01-2014, 02:46 PM

Here is a step by step process with pictures: http://www.contextures.com/xlDataVal02.html

**masood78** · 05-01-2014, 10:10 PM

I'm looking for dependent list populated based not only single selection but also multiple selection. Sample file is attached.

**Pauleyb** · 05-02-2014, 11:03 AM

Hmmm, okay. I usually use ActiveX controls as they seem more accessible and provide more features. Not sure what your VBA level is, but I'll assume you are getting stuck on determining what was selected and/or how to populate and know how to loop through cells and perform comparisons.

sheets("Sheet1").listboxes(1).selected(x)
will tell you if item number x is selected in the first listbox. If true, then you will need to use something like this to add an item to the second listbox:
sheets("Sheet1").listboxes(2).additem range("S4")

Creating a Range of a Listbox based on the Selection Made in Another ListBox

LinkBack

Thread Tools

Rate This Thread

Display

Creating a Range of a Listbox based on the Selection Made in Another ListBox

Re: Creating a Range of a Listbox based on the Selection Made in Another ListBox

Re: Creating a Range of a Listbox based on the Selection Made in Another ListBox

Re: Creating a Range of a Listbox based on the Selection Made in Another ListBox

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Indexing proper range in listbox depending on selection in previous listbox

[SOLVED] Update image based on listbox selection and fill listbox on workbook open

Multi select Listbox Items selection based on other Listbox item selection.

populate listbox based on selection in previous listbox

Listbox-how do I terminate/close the listbox after the user made one selection?

Bookmarks

Bookmarks

Posting Permissions