Don't want to use a button to run your macro? In this video, we cover the Worksheet Activate event which enables the macro to run automatically when your chosen sheet is selected, without requiring a button. We first create a macro which refreshes the currency data in our sheet and displays a message once it has refreshed. We then use the Worksheet_activate method to call this macro once the Currency Converter sheet is selected.
Access the templates featured in The Excel Hub's video tutorials here:
[ Ссылка ]
Create A Live Currency Converter In Excel:
[ Ссылка ]
Workbook Open Method - Display Welcome Message When Workbook Is Opened:
[ Ссылка ]
Worksheet Change Method - Run VBA Macro When Cell Value Changes:
[ Ссылка ]
Subscribe for weekly Excel tutorials, techniques and examples:
[ Ссылка ]
Please share this video with others that may find it useful:
[ Ссылка ]
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: [ Ссылка ]
📸 Instagram: [ Ссылка ]
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview (0:00)
Build Macro: (0:46)
Worksheet Activate Method: (1:35)
