help me with this problem plzz

wintersnow · #1 (**permalink**) 12-03-04, 00:51

can anyone help me out on this qns plz?

how do you write the code for the following situation:

if there are sheet1 and sheet2, and the cells correspond to each other,how do u type the code for macro in VB? when any cells in sheet2 is being edited, moved or deleted, the corresponding cells in sheet 1 is being highlighted automatically

plz help me ASAP by posting the code on this thread or send the codes to et85_wintersnow@hotmail.com

DavidCoutts · #2 (**permalink**) 12-03-04, 04:45

Something like this

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Worksheets("Sheet2").Range(Target.Address).Value <> _
            Worksheets("Sheet1").Range(Target.Address).Value Then
        Worksheets("Sheet1").Range(Target.Address).Interior.ColorIndex = 3
    End If
End Sub

dave

Internet Services

Web Development

Digital Marketing

Consumer Tech