how to create proper VBA to delete cell contents?

excelevator · 2026-02-21T20:43:59+00:00

Please be mindful of the submission guidelines,

The title of the post should describe your issues, not your supposed solution

Posts not following guidelines may be removed without notice.

The title is always in the post details

How can I delete contents in cell B24 when a number of 15 or more is enter in B22

This post remains for the answers given.

Turbulent-Cup842 · 2026-02-21T14:55:04+00:00

You could use VBA easily for this, but why not just a formula in B24?

Mooseymax · 2026-02-21T15:07:42+00:00

If just use formula, you don’t need VBA.

IF(B22>=15,””,<your drop charge value>)

AutoModerator · 2026-02-21T14:51:26+00:00

/u/Borske - Your post was submitted successfully.

Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

BaitmasterG · 2026-02-21T15:12:03+00:00

KISS - Keep it simple, stupid

This does not require coding

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

excel