Hi all,
I want to run multiple event macros in the same sheet but being a newbie, I can't figure out how to do it. Below are my two events.
Please Login or Register to view this content.Thank you for your time and help.Please Login or Register to view this content.
Last edited by itskenn1; 08-01-2021 at 02:55 AM.
You can run multiple event macros as long as they are not of the same type. You have one Worksheet_SelectionChange macro and one Worksheet_Change macro so that is OK.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks Mumps1
Actually that's exactly what I thought too and I tried it but it didn't work. So now I'm wondering, should I "end sub"? If not how do I make it work without "End Sub"?
You can't!!! It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
Thanks Mumps1 I really appreciate you taking the time. You know what, I'm using it in different sheets now. However I'll attach a copy once I have a proper structure of the file since I'm still in the process of designing.
You probably just need this:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Should have said ... this
will fire the Worksheet_Change event handler.Please Login or Register to view this content.
Hi TMS,
Thank you so much... it worked like a charm.
This is what I did with TMS's suggestion.
As you can see these are two macro events and they are now working without any error.Please Login or Register to view this content.
Thanks again.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks