+ Reply to Thread
Results 1 to 4 of 4

Auto Clear Multiple Dependant Dropdown Lists

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    Auto Clear Multiple Dependant Dropdown Lists

    On my worksheet, i have around 15 different dropdown lists that all work off variable inputs.
    I have a Working VBA Code that allows me to clear contents of one cell if the input is changed, but as a VBA novice i cannot adapt it to work with different inputs and outputs. I have tried searchign the forums, but can only find references to where people want to clear one cell.

    Please Login or Register  to view this content.
    This is what im working with at the moment but want to add in more variables such as if "D4" is changed then clear "E4:H4" same with D5- E5:H5 ect
    Any help would be apriciated.

    Also there are other parts in the spreadsheet that i could use this on, but again on the same page so eg, if B4 is changed then clear B5, so all of the changes are not in a linear fashion.

    Thanks in advance for anything you can do to help.
    Last edited by Nexial; 04-01-2014 at 08:14 AM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Auto Clear Multiple Dependant Dropdown Lists

    Hi Nexial and welcome to the forum,

    Could you edit your post above and select the code and then click the "#" icon to put code tags around it, so it looks like the below and your possible answer.

    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-01-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Auto Clear Multiple Dependant Dropdown Lists

    Such a simple solution, Thanks for the quick reply!

    Thanks for not looking down your nose at me, like many do to new poster, +Rep for the help

    Edited code as requested
    How do i link the thread as solved?
    Last edited by Nexial; 04-01-2014 at 08:19 AM.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Auto Clear Multiple Dependant Dropdown Lists

    To show "Solved" you need to edit the original post, go to advanced and change the prefix (I think).
    Thanks for the rep, and no question is too small or stupid if you don't know the answer. After you see it and understand it you too can start helping others. I know this by experience.

+ 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. dependant 4 dropdown lists vba code. Help pls
    By Milan Bhatia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2013, 08:55 AM
  2. Dependant dropdown lists
    By Adamitus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2012, 12:36 PM
  3. Replies: 8
    Last Post: 06-01-2011, 07:11 AM
  4. Dependant Dropdown Lists or another way?
    By ArnyVee in forum Excel General
    Replies: 1
    Last Post: 03-05-2009, 05:18 PM
  5. Dropdown dependant auto population of cells
    By swmasson in forum Excel General
    Replies: 3
    Last Post: 11-10-2008, 12:11 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