+ Reply to Thread
Results 1 to 1 of 1

Google Sheets script to Excel VBA, dependent drop down lists.

  1. #1
    Registered User
    Join Date
    05-19-2019
    Location
    America
    MS-Off Ver
    2019
    Posts
    13

    Google Sheets script to Excel VBA, dependent drop down lists.

    I found a Google Sheets file that contains a script. It does a few things with data validation. Among them, I believe it makes multiple dependent drop down lists dependent on all lists that come before it, and it only requires one data table, which is is arranged in a specific way that I need. For example, the 3rd drop down list is dependent on BOTH the 2nd AND 1st drop down lists that come before it, not just the 2nd list like usual. As a result, only criteria that matches the 2nd and 1st drop down values will show up under the 3rd list.

    In my case, I have the dependent drop down lists Brand, Type, Product, and Size. The correct products need to show up under the correct brands and types. In Excel, I have found out how to do this a different way, without VBA and with using more tables, but it's not quite what I want and is too messy.

    Is it possible to modify the script in the Google Sheets file to work in VBA for Excel?

    Because I am too new, I cannot post links yet. So I have attached an Excel workbook that contains the link to the Google Sheets file/example I am describing. Also, the script can be found either in the workbook on the 2nd page, or in the Google Sheets file, although it is much easier to read in the GS file because it is color coded there.

    Thank you so much for your time, I really appreciate anyone who even reads this.
    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. [SOLVED] dependent drop down lists on multiple lines (google sheets)
    By chrisk67 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 10-16-2018, 08:54 AM
  2. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  3. [SOLVED] Excel Dependent drop down lists
    By JAKIV in forum Excel General
    Replies: 4
    Last Post: 02-14-2018, 06:38 PM
  4. Google Sheets Script not working
    By jsmity in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-02-2017, 11:36 AM
  5. google sheets button with script
    By tselek1985 in forum Excel General
    Replies: 1
    Last Post: 10-17-2016, 06:18 AM
  6. Replies: 5
    Last Post: 02-12-2015, 01:18 PM
  7. 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

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