Two Way Cell Value Connection A1-C1 and C1-A1
Hello,
I am wondering if anyone knows a visual basic method to update the
values of two cells in visual basic so one is equal to the other if it
changes.
For example, if I change A1 to be "5" I want C1 to be updated to "5"
_and_ if I change C1 to be "5" I want A1 to be updated to "5" as well.
I've been searching for a cell(s).change option but was not able to
find that function, does anyone have any suggestions or guesses?
Thanks everyone for your help!
Shaun
|