Need help running a background macro for my whole sheet

I am trying to have my worksheet update the cell below the cell selected, based off what is in the cell. I have it figured out and working for one cell is there a what to do this with out writing the same code over and over again, I am pretty new to VBA and this is built off of a bunch of code searching:

Please Login or Register  to view this content.

I tried updating the range to include all the cells I want to accomplish this for with no luck. Any help would be great! thanks in advance

On the face of it your requirement is simple.

However no-one can help you.

Please insert the code tags so we can help.


Your post does not comply with Rule 2 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.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

Ok.

You have pasted two codes do you need them both?

The workbook activate code and the Change Code?

Also what addresses are you interested in or is it all of them?

This was based off my findings in another forum that the first one runs when the sheet is activated and the second one whenever there is a change. If this isn't needed I can keep just the change one but I would like it to run continuously in the background, again pretty new with VBA so not sure if this is the best way to accomplish my above goal. There are multiple sheets that all need the same logic applied so if there is a way to have it apply to all addresses that would be great, if not then for most of the sheets it D15:Q96.

This code works on all cells on a single sheet:

Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

With a couple of small changes the Macro will work on all worksheets.

Delete the Original Macro

Select the developer tab
Select view and then project explorer
Select your project
Double Click on ThisWorkbook
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

Firstly:

Adding this code to the "ThisWorkbook" module will update D16 each time you select a worksheet.

Please Login or Register  to view this content.

Secondly:

Not sure what you are asking. The Macro will continue to run as long as events are eabled.

If a Macro is used to clear the workbook. Then add this line to the end of that macro,

Please Login or Register  to view this content.

See attached template example.

Edit your post. Click on Advanced at the bottom, then click om Manage attachments

You must start your clear Macro with

Please Login or Register  to view this content.

This will stop macros running while you clear the cells

Please Login or Register  to view this content.

Does this Version of Reset work?

Please Login or Register  to view this content.

Please Login or Register  to view this content.