VBA Express : Excel - Automatically Delete Rows Based On User Input

Excel

Automatically Delete Rows Based On User Input

Ease of Use

Easy

Version tested with

2002

Submitted by:

Jacob Hilderbrand

Description:

This macro deletes an entire row based on a specific input.

Discussion:

You want to delete a row easily, and this macro allow just that. Input a "d" in Column C and that row is automatically deleted.

Code:

instructions for use

			Option Explicit 
 
Private Sub Worksheet_Change(ByVal Target As Range) 
     
    If Not Target.Column = 3 Then 
        Exit Sub 
    End If 
     
    If Target(1, 1).Value = "d" Then 
        Target(1, 1).EntireRow.Delete 
    End If 
     
End Sub

How to use:

Open Excel.
Right click on the sheet tab that you wan to code to work on and select View Code.
Paste the code in the Code Window that opens up.
Close the VBE (Alt + Q or press the X in the top-right corner).

Test the code:

Type d in any cell in Column C and that row is immediately deleted.

Sample File:

DeleteRows.zip 6KB

Approved by mdmackillop

This entry has been viewed 236 times.