ClearContents of particular cells if the contents of another cell is deleted

[nixonquierre]

Hi everyone,

Can someone help me with my problem? I am actually new to vba.


I want to automatically clear the contents of certain cells if the contents of "B15" is deleted. It is working, but the problem is whenever I delete the contents of "O7" or "O8". It will also clear the cells. This should not happen. Please help me.

BELOW IS THE CODES;

Please Login or Register  to view this content.

[TMS]

Think this

Please Login or Register  to view this content.

needs to be this

Please Login or Register  to view this content.

Otherwise, you are comparing the values of the cells. And, if B15 is blank ...


Regards, TMS

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[nixonquierre]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Im sorry, I didn't consider that. Thanks for the reminder

[nixonquierre]

Think this

Please Login or Register  to view this content.

needs to be this

Please Login or Register  to view this content.

Otherwise, you are comparing the values of the cells. And, if B15 is blank ...


Regards, TMS

Thank you so much TMS for your help. I works fine

I cant believe it. the only word missing is Adress! haha.,.

[TMS]

You're welcome.

But it makes a big difference. The default property for a range, I believe, is Value. So, in your original code, you are comparing the values in two cells, not the addresses of those two cells.


Regards, TMS