Clearing cells when another cell becomes populated

[Lobz]

I am very new to vba and macros and I am trying to clear cells automatically when another cell gets a value put into it. An example would be: If C3 has a value, clear B3, but I'd like it to do that to an entire table range. I've used this code:
Sub CLEARCELLS()



If Sheet1.Range("C3").Value <> "" Then

Sheet1.Range("B3").ClearContents

End If



End Sub

It works perfect for that particular cell, but I need it to cover all of column B & C and I'm pretty stuck since this is all new to me. Any help would be appreciated, thank you.

 

[My Aswer Is This]

So, when you enter a value in Range("C3") you want columns C and B cleared.
Is that what you want?

So, the value you just entered will be cleared also

 

[My Aswer Is This]

Ignore previous post:

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

If you enter any value in column C the value in same row column B will be cleared

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  11/12/2022  10:11:27 PM  EST
If Target.Column = 3 Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Application.EnableEvents = False
If Target.Value <> "" Then Target.Offset(, -1).Clear
Application.EnableEvents = True
End If
End Sub

 

[Lobz]

You are a gentleman and a scholar. I'm still learning all of this and that is exactly what I needed. The only adjustment I did was change (.clear) to (.clearcontents) to keep my other formatting. Great help and thank you.

 

[Lobz]

ok, it worked great on the tester sheet I set up but when I added it to the sheet, I am applying it to, I think it interferes with another worksheet change I have in place for barcode tracking. Is it possible to have multiple worksheet changes?

 

[Michael M]

No, you can't have multiple worksheet changes on the one sheet, but it may be possible to combine them into 1.
Post the other code you are currently using and someone may be able to help you.

 

[My Aswer Is This]

ok, it worked great on the tester sheet I set up but when I added it to the sheet, I am applying it to, I think it interferes with another worksheet change I have in place for barcode tracking. Is it possible to have multiple worksheet changes?

Post all the code you want in this sheet here so I can help.
Yes two sheet change event scripts can be in the same sheet if we post it correctly.
Post those two codes here and I will show you how to combine them

 

[Lobz]

Private Sub Worksheet_Change(ByVal Target As Range)


If Not Intersect(Target, Me.Range("B2")) Is Nothing Then

Call leaving
Application.EnableEvents = True
End If

End Sub
Sub ClearCell()

If IsDate(Range("C4:C1000").Value) Then
MsgBox ("Cells")
End If

End Sub

Sub ClearLocation()

If Range("c4:c1000") <> "" Then
Range("b4:b1000").ClearContents
End If

End Sub

This is the code that I have based of a template I found, I know there is a cleaner way to write this code too, and it is connected to 2 previous sheets that record barcode entries with time in/time out and location. What I am trying to achieve is to have the location column clear on this sheet when it has been scanned out because I have the locations on this sheet linked to another location sheet and I don't want them to remain on the final location page if they have been scanned out.

 

[My Aswer Is This]

Private Sub Worksheet_Change(ByVal Target As Range)


If Not Intersect(Target, Me.Range("B2")) Is Nothing Then

Call leaving
Application.EnableEvents = True
End If

End Sub
Sub ClearCell()

If IsDate(Range("C4:C1000").Value) Then
MsgBox ("Cells")
End If

End Sub

Sub ClearLocation()

If Range("c4:c1000") <> "" Then
Range("b4:b1000").ClearContents
End If

End Sub

This is the code that I have based of a template I found, I know there is a cleaner way to write this code too, and it is connected to 2 previous sheets that record barcode entries with time in/time out and location. What I am trying to achieve is to have the location column clear on this sheet when it has been scanned out because I have the locations on this sheet linked to another location sheet and I don't want them to remain on the final location page if they have been scanned out.

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Lobz]

Thank you for your help on the original question. I might have to make a duplicate page or something to run it. I'm still learning and will figure something out.