Results 1 to 11 of 11

Initial default drop downs and dependent default drop downs

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2016
    Location
    South Florida
    MS-Off Ver
    2016
    Posts
    6

    Initial default drop downs and dependent default drop downs

    I have 5 drop down lists in the B column. I can currently choose a food type(b1) and the respective food type lists will populate the remaining drop downs(b3-b6). On the data tab I have the named ranges and all drop down lists are populated through data validation.

    What I would like to do is select a food type and the remaining drop downs would show a default selection. I put item numbers in the A3-A6 labels to show that whatever food type is selected, I would like the food items to show in that order based on the list that is on the data tab (i.e. If "fruits" is selected then the drop downs would show banana, then apple, pear, and orange. If "vegetables" they would show broccoli, carrot, onion, then corn). Every time the food type is changed, the rest of the drop down defaults are populated with the correct defaults, however, if someone is to change the item drop down lists after the initial defaults, they would be able to do without issue.

    I understand this is probably a VBA thing and I am quite new to it. I know there is a way to do it by case and type in the string literals, but I would prefer pulling by the position in the list as I have many dependent drop down lists.

    Also, I would like to set an initial default for when the workbook is pulled up, so it can show an example of the fully filled out form.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dependent Drop Downs
    By Bumblbree in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2016, 11:45 AM
  2. [SOLVED] Dependent drop downs
    By gameplayer in forum Excel General
    Replies: 2
    Last Post: 12-04-2015, 11:49 AM
  3. [SOLVED] Dependent Drop-Downs (Indexed)
    By BobBing in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2012, 05:33 PM
  4. Creating dependent drop downs
    By harrybelly in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:08 PM
  5. Dependent Drop-Downs
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:06 PM
  6. Auto-update initial drop-down selection based on previous drop-downs
    By thornomad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 09:55 AM
  7. Dependent drop downs.
    By Mattypb in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-16-2009, 08:47 AM

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