Results 1 to 4 of 4

Auto Clear Multiple Dependant Dropdown Lists

Threaded View

  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.

    Option Explicit
    
    
    Private Sub Worksheet_Change(ByVal Target As Range)
    
        If Target.Cells.Count > 1 Then Exit Sub
        
        If Not Intersect(Target, Range("D3")) Is Nothing Then
            Range("E3:H3").ClearContents
    
                    
            End If
            
            
    End Sub
    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.

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