Amazing Macros |
|---|
| Course Outline |
Outline
|
| Introduction |
Intro-MOC50476.pptx
|
| Reading Material |
|
| Demo |
|
| Module | Topics | Sharing |
|---|
| 1 |
- Opening a Workbook Containing Macros
- Running a Macro
- Using a Shortcut Key
- Using the Visual Basic Toolbar
- Opening the Visual Basic Application Window
- Using the Visual Basic Application Window
|
|
| 2 |
- Using the Developer Tab
- Recording a Macro
- Assigning a Shortcut Key
- Using Relative References
- Deleting a Macro
|
|
| 3 |
- Writing a New Macro
- Entering Macro Comments
- Copying Macro Commands
- Editing Macro Commands
- Typing Macro Commands
- Create Message Box
- Running Macro from the Code Window
- Using the Debugger
|
|
| 4 |
- Creating a Custom Button
- Adding a Button to Quick Access Toolbar
- Assigning a Macro to a Button
- Changing a Button Image
- Deleting a Custom Button
|
|
| 5 |
- Creating a Macro Button
- Copying a Macro Button
- Formatting a Macro Button
- Moving/Sizing a Macro Button
- Deleting a Macro Button
|
|
| Recommanded Books |
|---|
 | Title | Excel VBA Programming: Task Optimization and Daily Work Automation |
|---|
| ISBN | 979-8-854-42615-2 |
|---|
| Author | Kiet Huynh |
|---|
| Year | 2023 |
|---|
| Publisher | Independently published |
|---|
 | Title | Excel VBA Programming For Dummies: 6th Edition |
|---|
| ISBN | 978-1-119-84307-8 |
|---|
| Author | Dick Kusleika |
|---|
| Year | 2022 |
|---|
| Publisher | For Dummies |
|---|
 | Title | Practical VBA For Practically Anyone: For When You Know What You Want To Do But Don't Know How To Do It |
|---|
| ISBN | B09672RDM7 |
|---|
| Author | McSweeney, Gerry |
|---|
| Year | 2021 |
|---|
| Publisher | |
|---|
 | Title | VBA Automation for Excel 2019 Cookbook-Solutions to automate routine tasks and increase productivity with Excel |
|---|
| ISBN | 978-1-789-61003-1 |
|---|
| Author | Van Niekerk, Mike |
|---|
| Year | 2020 |
|---|
| Publisher | Published by Packt Publishing Ltd. |
|---|
 | Title | Microsoft Excel 2019 VBA and Macros |
|---|
| ISBN | 978-1-509-30611-4 |
|---|
| Author | Bill Jelen, Tracy Syrstad |
|---|
| Year | 2019 |
|---|
| Publisher | Microsoft Press |
|---|
 | Title | Mastering VBA 2019-For Microsoft Office 365, 2019 Edition |
|---|
| ISBN | 978-1-119-57933-5 |
|---|
| Author | Richard Mansfield |
|---|
| Year | 2019 |
|---|
| Publisher | Sybex Inc |
|---|
 | Title | Excel 2019 Power Programming with VBA |
|---|
| ISBN | 978-1-119-51492-3 |
|---|
| Author | Michael Alexander, Richard Kusleika |
|---|
| Year | 2019 |
|---|
| Publisher | Wiley |
|---|
 | Title | Excel VBA Programming for Dummies |
|---|
| ISBN | 978-1-119-51817-4 |
|---|
| Author | John Walkenbach |
|---|
| Year | 2018 |
|---|
| Publisher | Wiley |
|---|
 | Title | Programming Excel with VBA-A Practical Real-World Guide |
|---|
| ISBN | 978-1-484-22204-1 |
|---|
| Author | Flavio Morgado |
|---|
| Year | 2016 |
|---|
| Publisher | Apress |
|---|
 | Title | Excel VBA 24-Hour Trainer |
|---|
| ISBN | 978-1-118-99137-4 |
|---|
| Author | Tom Urtis |
|---|
| Year | 2015 |
|---|
| Publisher | Wrox |
|---|