+ Reply to Thread
Results 1 to 3 of 3

VBA to auto clear multiple drop downs in single sheet

  1. #1
    Registered User
    Join Date
    09-18-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    2

    VBA to auto clear multiple drop downs in single sheet

    Hello,

    Hoping you can help.


    I have a sheet with five tables, each table has two drop downs that the formula depends upon. However, for the formulas to work correctly, criteria is only needed in one of the drop down menus, and the other menu should remain blank.

    I would like to be able to select an option from either drop down and for the other drop down menu to clear. So if C6 = selected, C5 = clear and vice versa. I then need this across all 5 tables, and each table and set of drop downs being treated independently.

    I have found a code that allows it to work one way on one of the tables, but not the other way.

    (To clarify by table, I do not mean an excel table. It is just a normal grid made up of formula, if that makes any difference)

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,355

    Re: VBA to auto clear multiple drop downs in single sheet

    1) Copy this code.
    2) Right-Click the sheet tab of interest.
    3) Select "View Code"
    4) Paste the code into the window that appears.
    5) Save the file as a macro-enabled .xlsm file.
    6) Make changes as needed


    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    09-18-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    2

    Re: VBA to auto clear multiple drop downs in single sheet

    Good morning,

    Apologies for the delay in getting back to you. I was at a conference yesterday and unable to try this out. This worked perfectly! Thank you so much for this, really appreciated!

+ 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. How to auto copy the multiple sheet to single sheet
    By sudbhavani in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2017, 06:43 AM
  2. Trying to create a sheet that has drop downs with certain
    By RossLwn314 in forum Excel General
    Replies: 11
    Last Post: 01-18-2016, 12:39 AM
  3. [SOLVED] Multiple drop downs
    By Treecko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 07:24 PM
  4. Replies: 17
    Last Post: 02-05-2013, 08:20 PM
  5. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 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. Purchase Order with Drop downs that will Auto fill typical informa
    By rsera in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2005, 01:06 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