They can't both contain a formula that refers to the other cell without
getting a circular reference error unless you have unchecked iterations in
the options=Calculate tab. If you have, then you can do it with the change
event as suggested by John.

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.

--
Regards,
Tom Ogilvy

"Jan Jansens"
wrote in message
...

no really John....
1) User can enter a value both in A1 or A2 ...if he enters a value in
A1 then value in A2 changes, if he enters a value in cell A2 then value
in cell A1 changes....
2) so both A1 and A2 contain a formula but can also take values....(or
so it looks)


Thanks for taking a look at this.....


--
Jan Jansens
------------------------------------------------------------------------
Jan Jansens's Profile:
http://www.excelforum.com/member.php...o&userid=26982
View this thread: http://www.excelforum.com/showthread...hreadid=406186