There is no way to do this without a Change event.
Assuming your two cells are A1 and B1:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "A1" Then
Range("B1") = Target.Value
ElseIf Target.Address(False, False) = "B1" Then
Range("A1") = Target.Value
End If
End Sub

Regards,
Stefi

€žHenrik€� ezt Ã*rta:

Is it possible to have two input cells more or less 'alternating' so that
each cell assumes the most recent value in either cell?

An example to illustrate: the two cells start empty. A value is entered in
either of the two cells, and both cells now have that value. Aother value is
entered in either cell, and the two cells now have that value.

Ideally I'd like to avoid using VBA. Any ideas?

Henrik