+ Reply to Thread
Results 1 to 4 of 4

multi level dependent drop down list

  1. #1
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    multi level dependent drop down list

    Hello

    I'm made a multilevel dependent Comboboxes in vba but now I need to make the same boxes but as 3 drop-down lists in excel.
    Is it possible to do so with the current table?
    Attached Files Attached Files

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: multi level dependent drop down list

    I do not understand the structure of your table.
    Look at the attached using table format to load the combos dependent upon previous choice.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Re: multi level dependent drop down list

    Quote Originally Posted by torachan View Post
    I do not understand the structure of your table.
    Look at the attached using table format to load the combos dependent upon previous choice.
    I used this website to create the comboboxes in userform.

    http://://www.pk-anexcelexpert.com/v...-in-user-form/

    now I need the same result that I see in userform (comboboxes) but in a worksheet like 3 drop-down lists.

    I was wondering if it's possible to make a drop-down list using the (data > data validation >list) and functions to create these lists without changing the table I have

  4. #4
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Re: multi level dependent drop down list

    I found a solution and I'm posting this, in case someone else has the same problem
    Attached Files Attached Files

+ 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. 3 level dependent drop-down list in excel
    By TJ7009 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-01-2020, 04:57 AM
  2. [SOLVED] creating Multi-level list styles using existing multi-level list?
    By JimmyWilliams in forum Word Formatting & General
    Replies: 2
    Last Post: 08-28-2017, 12:21 AM
  3. [SOLVED] Multi Level Dependent Drop Down Lists
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2015, 03:35 PM
  4. Multi Level Dependent Drop-down list, Explanation required
    By Shoieb.arshad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2012, 11:36 AM
  5. Drop Down Issue - multi level filter
    By burblecut in forum Excel General
    Replies: 3
    Last Post: 08-19-2010, 04:54 PM
  6. Excel 2007 : multi level dependent list
    By MWinder in forum Excel General
    Replies: 3
    Last Post: 05-12-2010, 11:31 AM
  7. Multi-level dependent lists
    By aussiemate in forum Excel General
    Replies: 6
    Last Post: 02-25-2010, 04:02 AM

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