MM0054 - 14/12/20 - Excel VBA Christmas Carol Challenge 2
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!
All download files can be found here:
Topics
All download files can be found here:
Topics
- | Iain L - Homework Review
- | Optimise Display With Text Wrap / Row Height
- | Example Of User-Adjustable Parameter
- | User Input Cell Formatting Example
- | How To Insert An Icon
- | Dealing With Different Screen Resolutions
- | Engine Sheet Or No Engine Sheet?
- | Why Declare Variable At Top Of Module?
- | Write Out What You Intend To Do
- | Two Generic Module Names
- | How To Continue Instruction On New Line
- | Alt + H + F + S Shortcut
- | When To Copy An Existing Button
- | How To (Un!)hide Excel
- | Why A 'Modular' Approach Is Best
- | Error Message When Outside The Spreadsheet
1 Lesson