I am trying to figure out how to have one cell point to the contents of another cell using VBA. For example, have cell A2 equal the contents of cell A1 such that if the user of the excel spreadsheet changes the contents of A1, cell A2 will automatically reflect that change.

If in excel I type into cell A2: "=A1", then when the contents of A1 changes, A2 automatically changes. That is what I want to accomplish, but with VBA.

Using VBA, if I set A2 = A1, cell A2 is set to the current value of A1, and A2 does not change if the user changes the value of A1.

Hope my description is clear. Any help would be appreciated.

--Steve

Hi,
You can use worksheets Change event

Private Sub Worksheet_Change(ByVal Target As Range)
    Range("A2") = Range("A1")
End Sub

-vemaju

I think that will do the trick, thanks very much for your help.