200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Any advice appreciated.
I have Worksheet_Open code in ThisWorkBook which obviously performs actions when the spreadsheet is opened. What I woud like to do is get the same code to run when a Worksheet_Change event occurs in a particular sheet.
Assuning I can't combine Worksheet_Open & Change in a single module(?) how can I call one from the other?
Apologies if this is a question driven by general lack of appreciation of the structure of VBA but any input would help.
Thanks
JK
Basically, they call themselves when an action happens.
If you want a particular piece of code to be executed by either of them then just put the macro into its own section in a Module and call the macro from the Worksheet_Open and Change events.
This way, you can access the code from wherever you want in the VBA environment.
To call the macro, you basically just write:
Call macros_nameHere is a small tutorial on it: call a macro from another macro