VBA needed to make cell deleted if another cell value is exist

[love_guy_1977]

Hi guys,

I'm looking for vba that do the following:

Say eample:

---1---2---3
A-Man-5---

===============
---1---2---3
A-Man- ---5

===============
---1---2---3
A-- --- ---


A1 must be filled then enter number in A2 or A3. Meaning can't enter value in A2 and A3.

So if A1 is entered, then you enter 5 in A2. If you enter any number in A3, value of A2 will be deleted.

And contrary, if A1 is entered, then you enter 5 in A3. If you enter any number in A2, value of A3 will be deleted.

One more that, no value allowed in A2 or A3 if A1 is empty


Thank your very much

 

[love_guy_1977]

See this file then you may help me

Grean cell must be filled, then yellow cell as Debit / Credit must one of them to be entered

http://www.mediafire.com/?pp21y1d4j11gc5z

Thank you