Delete cell without from other cell

[deraco123]

How folks

I was looking for the answer for following question.

I need formula which delete text in A1 once some text in B1 is entered.
However formula canot be in A1.

I did not find anything....

Thanks

 

[Peter_SSs]

How folks

I was looking for the answer for following question.

I need formula which delete text in A1 once some text in B1 is entered.
However formula canot be in A1.

I did not find anything....

Thanks

You would not be able to do that with a formula - you would need some vba code. If that is acceptable, please advise if A1 is to be deleted when anything is entered into B1, or only if some particular entry (what?) is made in B1.

 

[deraco123]

Hi
thanks for reply
A1 should be deleted when anything is entered into B1.
VB is OK

Thanks

 

[Peter_SSs]

Hi
thanks for reply
A1 should be deleted when anything is entered into B1.
VB is OK

Thanks

Try this worksheet change code.

1. Right click the sheet name tab and choose "View Code"

2. Copy the code below and paste into the main right hand pane that opens at step 1.

Cloese the VB window and test.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Change(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range)<br>    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Not</SPAN> Intersect(Target, Range("B1")) <SPAN style="color:#00007F">Is</SPAN> <SPAN style="color:#00007F">Nothing</SPAN> <SPAN style="color:#00007F">Then</SPAN><br>        <SPAN style="color:#00007F">If</SPAN> Range("B1").Value <> "" <SPAN style="color:#00007F">Then</SPAN><br>            Range("A1").ClearContents<br>        <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[deraco123]

Works
thank you very much