Change cell based on value

[akhileshgs]

Hi All,

I have 2 sheets in a workbook, Cover_Sheet & Parameters

What i am trying to do is, If value of 'C2' changes to 1 in Cover_Sheet, Value of 'B3' in Parameters sheet should convert to "ABC"

I have written following code for that

Sub Worksheet_Chan(ByVal Target As Range)
If Worksheet("Cover_Sheet").Range("C2").Value = "1" Then

Range("B3").Value = "ABC"

    End If

End Sub 

and pasted that in the VBA of 'Parameters' Tab

But it is not working. Can anyone please help?