Assigning Event handler to a button

Hello there,

It is my first post, so I will like to say thanks to everyone who has helped somebody in one way or the other on this forum. I have been able to work around some vba issues just by reading the answers from other threads.
I am new to vba programming in excel so my question might look simple but I have battled with it for hours, SOS any one.

the code I created, works well and triggers for individual cells in the range but prematurely, instead I want to be able to click a button
after I have inputed all the data so that the event handler will then run through my target named range before calling the concerned macro email automation.

Hope my explanation is clear a little, my coding might also be amateurish. bear with me.

thanks in advance.

Please Login or Register  to view this content.

If you want the code to run only when the button is pressed get rid of the Change event.

Then transfer the code into a sub in standard module, something like this,

Please Login or Register  to view this content.

and then either assign this to your (Forms) button or call it from your (ActiveX) button.

PS Can you add code tags when posting code?

Is there a way to tell which data in the range is new?

For example, a column with the date?

Or perhaps a column with a status?

Could you upload an example workbook with dummy data?

Include some old and new dummy data and indicate the rows for which an email should be sent.

okay. how do I attach here.
I have tried the attach tag, still a newbie.