+ Reply to Thread
Results 1 to 5 of 5

VBA for dropdowns based on another dropdowns

  1. #1
    Registered User
    Join Date
    08-10-2016
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    67

    VBA for dropdowns based on another dropdowns

    Hello Everyone,

    I need to create dropdowns based on another drop downs. I know to create using data validations, but there are 100's of values in dropdown. Hence thinking of using vba code. Anyone, please help me out. The data is in the below format in different columns. Like if I select A in dropdown, AA1 should appear or if I select B, BB1 & BB2 should appear in another dropdown.

    A AA1
    B BB1 BB2
    C CC1
    D DD1 DD2 DD3
    E EE1 EE2 EE3 EE4

    Thanks in Advance.

    Best Regards,
    Abhi

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: VBA for dropdowns based on another dropdowns

    Maybe this can put you in good direction


    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-10-2016
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    67

    Re: VBA for dropdowns based on another dropdowns

    Thanks Leo...its working fine. But what if I am having only 3 values under A i.e. from A1 - A3 and rest are same. Dropdown values are uneven.

    Best Regards,
    Abhishek

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: VBA for dropdowns based on another dropdowns

    without exemple file we can only give
    something to put you in direction

    otherwise your file


    Kind regards
    Leo

  5. #5
    Registered User
    Join Date
    08-10-2016
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    67

    Thumbs up Re: VBA for dropdowns based on another dropdowns

    No worries....I got the solution. Instead of Count function in the formula you provided, I inserted the maximum value count of all the columns.

    Thank you very much.

    Best Regards,
    Abhi

+ 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. Autofill of cell data based on each other and allow dropdowns.
    By joplrw10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 12:53 PM
  2. [SOLVED] Choose Value From Table Based on 3 Dropdowns
    By Mathias25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2015, 05:38 PM
  3. [SOLVED] look up based on multiple dropdowns
    By nellyc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2013, 07:27 AM
  4. Replies: 3
    Last Post: 09-30-2011, 03:29 PM
  5. Excel 2007 : filtering dropdowns with dropdowns?
    By CADiphile in forum Excel General
    Replies: 2
    Last Post: 10-15-2009, 04:11 PM
  6. Triggering Different Dropdowns Based on Original Dropdown
    By Ziilch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2009, 08:09 AM
  7. Dropdowns and possible "sub dropdowns
    By LeonidasSaveUs! in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2008, 09:55 PM

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