View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shaun[_6_] Shaun[_6_] is offline
external usenet poster
 
Posts: 4
Default 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