Cannot link two cells between worksheets

[dimattia]

Hey, I'm new here and to vba so any help is greatly appreciated!

I want to be able to "link" two cells together so if you enter a value into one cell the other cell will match it, and vice versa. I can do this with two cells in the same worksheet, but I cannot figure it out if they are on different worksheets.

Here is the code I am using, and its in the "ThisWorkbook" section in "Microsoft Excel Objects" folder when you open vba.

Please Login or Register  to view this content.

I have tried several combos such as changing "Target.address (0, 0)" and nothing seems to work
Thank you in advance!

[ragulduy]

Try something like:

Please Login or Register  to view this content.

[tehneXus]

see two examples, the first creates a formula and the 2nd copies a value (workbooks have to be open)

Please Login or Register  to view this content.

[dimattia]

Thanks! Turns out I found a solution right as both of these were posted. This was the code I ended up using

Please Login or Register  to view this content.

Thanks alot and I will definetly play around with both your suggestions!