Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete cell contents once another cell has data

    Code:
    Good Evening, 
    
    I recently added an icon set with =sign to my workbook to monitor performance.
    Now unless every row has data i just get the numbers instead of the icon 1,0,-1
    If i add data to every row the icons appear as formatted "Confused"
    
    So i either need some code to help combat the conditional formatting issue "IF" maybe
    OR
    A code to delete cell G1 once data is entered into any cell within H1:DD1 as i have temporally added a blanket number in column G
    This code would need to be copied down for 40 rows in total.
    Thanks in advance for any help

    John
    Attached Images Attached Images

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    OR
    A code to delete cell G1 once data is entered into any cell within H1D1 as i have temporally added a blanket number in column G
    This code would need to be copied down for 40 rows in total.
    gribbin,

    If I understand you correctly, you are looking for code that will monitor data input in the range of H1 to DD40. If a change is detected anywhere in that range, the value in column G on the same row as the inputted value will ne deleted. The following code will do just that. No need to copy down any code

    HTH,
    Maud

    Place in the worksheet module:
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("H1:DD40")) Is Nothing Then
        Cells(Target.Row, "G") = ""
    End If
    End Sub

  3. #3
    New Lounger
    Join Date
    Jun 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Maudibe, That works perfectly. Nothing i searched on Google came up with anything as slick as this. Kudos

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •