I'm looking for a private worksheet change (or similar) macro that would clear the contents of cell L18 if cell L20 equals "TRUE".
I would be very grateful for any assistance!
I'm looking for a private worksheet change (or similar) macro that would clear the contents of cell L18 if cell L20 equals "TRUE".
I would be very grateful for any assistance!
Last edited by lilsnoop; 06-19-2021 at 07:36 AM.
Something like this without the action when L20 is False.
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(0, 0) <> "B11" Then Exit Sub Application.EnableEvents = False If [L20] Then [L18].ClearContents Application.EnableEvents = True End Sub
Thanks Jindon! That did what I needed. Really appreciate your assistance!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks