problem with setting up sheets

[danmen]

My workbook contains two sheets, A and B.

Depending on the values I type in sheet A, cell A1 of sheet B may change. If it does change I would like a macro to be executed that affects values in sheet B only, while I remain in A typing in new values

Can someone show me how to set this up?

thanks for any help

 

[VoG]

Try this: right click Sheet B's tab, select View Code and paste in

Private Sub Worksheet_Calculate()
Static OldVal
If Range("A1").Value <> OldVal Then
    OldVal = Range("A1").Value
    Application.EnableEvents = False
    Call MyMacro
    Application.EnableEvents = True
End If
End Sub

Change MyMacro to the name of the macro you want to run.

 

[danmen]

*perfect* !

thanks Peter, I'm so happy you're on these forums!

all the best to you