+ Reply to Thread
Results 1 to 2 of 2

Excel Cascading Listbox

Hybrid View

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Reading, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Excel Cascading Listbox

    Hi - I am trying to create a worksheet with three list boxes, which I would like to link and cascade, such that clicking a value in one box would filter the other box/es to just show values relating to that selection.

    I have picked up some code from here: http://www.cpearson.com/Excel/LinkedListBoxes.aspx
    However, it is quite slow, as I have a lot of values in two of my boxes.
    Does anybody know:
    a) how to speed this up or
    b) an alternative method

    I also do not want any of the listboxes to have a default value. The reason for this is that there are formulae built around the selections, which also apply an autofilter to data on another sheet. I need, when the sheet opens, to show all values (i.e. nothing selected), so the calculations can be applied to the entire dataset, with the user then able to drill down to the required level.

    Any suggestions welcome.

  2. #2
    Valued Forum Contributor AlvaroSiza's Avatar
    Join Date
    09-19-2007
    Location
    Staffordshire
    MS-Off Ver
    2007
    Posts
    591

    Re: Excel Cascading Listbox

    Does it have to be VBA/Listboxes? How many lists will comprise your "cascade"? Have you considered Dependent Lists via Data Validation as a non-VBA approach? http://www.contextures.com/xlDataVal02.html#Third
    Perhaps it was the Noid who should have avoided me...
    If you are satisfied with my solution click the small star icon on the left. Thanks
    1. Make a copy of your workbook and run the following code on your copy (just in case)
    2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
    3. Paste the code from above into the empty white space. Close the VBE.
    4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Editing listbox items in Dblclick event freezes Excel unless mouse moves over listbox
    By muneebmansoor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2013, 02:21 PM
  2. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  3. [SOLVED] Building multiple levels of cascading dropdowns in Excel
    By yinhugui in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2012, 11:55 AM
  4. Excel & cascading combos in a table
    By wildmantaz in forum Excel General
    Replies: 1
    Last Post: 05-13-2009, 07:49 PM
  5. [SOLVED] Create a cascading list box using Excel
    By JPB in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1