Cell Change Event (VBA)

I'll preface by saying that I know next-to-nothing about VBA.

I need to implement a Cell Change Event that if someone types anything in cell A1, cell C1 will be updated to say "banana" & if someone types anything in cell B1, cell C1 will be updated to say "strawberry". In turn, if after typing in B1, someone types in A1, C1 will change to "banana" again.

Short version: if someone types in A1 or B1, C1 changes, based upon the last change.

If any other cell is typed in, it does nothing.

Can anyone help me w/ code for this?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you SO much! That works great.

I may be pushing my luck here, but I just thought of another wrinkle that I overlooked:
Can I use named ranges in VBA? I tested your code & realized that I'm actually trying to apply it to a table.

So, ultimately, I'd be looking for it to anytime the was a change in ColumnA or ColumnB, it would be updating the cell in ColumnC, in the same row.

Something like:
Private Sub Worksheet_Change(ByVal Target As Range)

Select Case Target.Address(False, False)
Case "Table1[ColumnA]": Range("Table1[ColumnC]").Value = "Bannanas"
Case "Table1[ColumnB]": Range("Table1[ColumnC]").Value = "Strawberries"
Case Else
End Select

End Sub

Would that work? Or am I now asking too much?

Something like this

Please Login or Register  to view this content.