Beyond Macros |
|---|
| Course Outline |
Outline
|
| Introduction |
Intro-VBA015.pptx
|
| Reading Material |
|
| DAY | Topics | Sharing |
|---|
| 1 |
- Why use macros?
- Record Macros
- Playback Macros
- Delete Macros
- What actually the macro is?
- Error in recording
- Inefficient
- Extra code generated
- Not dynamic enough
- Straight to the point
- Better readability
- Less Error prone
- Faster execution
- Handle dynamic contents
- Using more advanced features
- Track user interaction with individual worksheet
- Handle Selection Changed
- Handle Worksheet content changed
- Handle user right click
- Handle user double click
- When worksheet become active or inactive
|
Day1.zip
|
| 2 |
- When user attempt to close the work book
- Initial your work when the workbook is opened
- Declare similar behavior for every worksheet in the workbook
- The purpose of form controls
- Advanced UI with form controls
- Linking form controls with macros
- The different between Form Controls and ActiveX Controls
- Activate macros using ActiveX controls
- Extending the worksheet model using ActiveX controls
- Using ActiveX button
- Using ActiveX Combo box
- The limitations of worksheet as user interface
- Alternative interface using User Form
- Showing, Hiding and closing User Forms
- Linking user forms with worksheets
|
Day2.zip
|
| 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 |
|---|