MM0053 - 07/12/20 - Excel VBA Christmas Carol Challenge 1
Welcome back to Members Monday!
All download files can be found here:
It's coming up to Christmas and that can only mean one thing - customised Excel VBA solutions! In this fun stream, we try to create a Christmas carol display tool for a local vicar. Can you implement the tool yourself, and can you do it in time for the Christmas carol service? The clock is ticking!
Though the application is fun, we apply a number of essential Excel VBA techniques in the implementation. Make sure you follow along and build it yourself ...
Topics
All download files can be found here:
It's coming up to Christmas and that can only mean one thing - customised Excel VBA solutions! In this fun stream, we try to create a Christmas carol display tool for a local vicar. Can you implement the tool yourself, and can you do it in time for the Christmas carol service? The clock is ticking!
Though the application is fun, we apply a number of essential Excel VBA techniques in the implementation. Make sure you follow along and build it yourself ...
Topics
- | Briefing - Christmas Carol Challenge
- | Keyboard Shortcut - Clear Formats
- | Keyboard Shortcut - Repeat Last Action (F4)
- | Conceptualise A Typical VBA Task
- | Keyboard Shortcut - Change Sheet Name (Alt+OHR)
- | Change Worksheet Name Using VBA
- | Loop Through All Sheet In File
- | VBA Error When Naming Sheets
- | Importance Of Right Sheets
- | Keyboard Shortcut - Dropdown (Alt+AVV)
- | Insert A Button To A Worksheet
- | Importance Of Metaskill
- | Refer To A Sheet With A Variable
- | How To Pass Information Between Macros
- | Do I Need A Named Range?
- | With … End With To Simplify - Example
- | Offset Example
1 Lesson