Results 1 to 3 of 3

Clear List Macro for Data Validation, Multiple Lines in table

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Morrisville, NC
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    43

    Exclamation Clear List Macro for Data Validation, Multiple Lines in table

    Good Afternoon. I have a spreadsheet where I am tracking several entries in a table that will keep growing. Three fields are Data Validation Drop Down Lists. The macro below works well to clear the two lists to the right when the first one is changed by the user.

    Option Explicit
     
    Private Sub Worksheet_Change(ByVal Target As Range)
         
        If Target.Cells.Count > 1 Then Exit Sub
         
        If Not Intersect(Target, Range("E5:E9001")) Is Nothing Then
            Range("F5").ClearContents
            Range("G5").ClearContents
        End If
         
    End Sub
    I am want this to affect the rows below it in the table as they are added.
    Last edited by gedwards913; 08-01-2014 at 03:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] validation list - clear
    By Lukael in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2014, 07:36 AM
  2. [SOLVED] Lookup multiple lines of data from a table
    By kelevra in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2013, 09:26 AM
  3. Data Validation List from Table Name Error
    By rosilisk in forum Excel General
    Replies: 2
    Last Post: 07-27-2011, 05:26 PM
  4. Filter a data validation list from a table
    By JackyJ in forum Excel General
    Replies: 1
    Last Post: 08-19-2010, 06:47 AM
  5. Clear cells depending on data validation list output
    By fergcu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2008, 05:11 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