+ Reply to Thread
Results 1 to 5 of 5

Dependent Drop Down Lists

  1. #1
    Registered User
    Join Date
    05-05-2018
    Location
    Uganda
    MS-Off Ver
    2016 Mac Edition
    Posts
    3

    Dependent Drop Down Lists

    Please Allow me to Explain my Situation:
    I work in Car Selling Company.
    We normally Have the followings:

    Make = Toyota, BMW etc, Model= Corolla X5 etc, & Model Codes (Model Codes are also known as First part of the Chassis or Win Numbers)

    I have Situation that under One type of Model Code (NZE121, there are Multiple Models E.g Corolla, Alex, Runs etc) and they all Belong to Toyota. Example Below:

    I am unable to attached the file will try, even ready to pay some bucks if can be fixed

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Dependent Drop Down Lists

    Hi, welcome to the forum

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

    Also, see if the attached will get you started. It is a 3-level dependent DD, but you should be able to adapt it to 2 levels
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,877

    Re: Dependent Drop Down Lists

    Look at this link for Dependent Combo Boxes.

    http://www.contextures.com/exceluser...omboboxes.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    05-05-2018
    Location
    Uganda
    MS-Off Ver
    2016 Mac Edition
    Posts
    3

    Re: Dependent Drop Down Lists

    Thanks for you Reply,
    I did tried going to Advance, Normal Attachment link after going in advance I can see, not sure may it is the Editor Compatibility issue on MacBook, but same attachment file I tired uploading to my Dropbox and paste link for you to look at, but It will not allow me to post links at this moment.
    I will download your given file and see the possibilities thanks.

  5. #5
    Registered User
    Join Date
    05-05-2018
    Location
    Uganda
    MS-Off Ver
    2016 Mac Edition
    Posts
    3

    Re: Dependent Drop Down Lists

    dropbox.com/s/g5vsvrlolp0971g/Yuasa%20Bond%20Keys_Test.xlsx?dl=0[/url]

    This is the file link I hope this time it allows me to save this link so you can down load sample file.

+ 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. Replies: 11
    Last Post: 10-08-2021, 04:55 AM
  2. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  3. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  4. dependent drop down lists
    By scorry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2013, 07:58 AM
  5. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  6. Dependent Drop Down lists (multiple drop down)
    By jijy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 09:56 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