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?

[Kaper]

Perhaps you should use

Please Login or Register  to view this content.

not just Chan
Moreover this code, if it is to react on manual changes in Cover_Sheet - shaall be inserted in Cover_Sheet code (so right click on Cover_Sheet tab, select Display code from popup and paste your code there.

if this code is to change B3 in Parameters to "ABC" then respective line shall read:

Please Login or Register  to view this content.