Coding in Visual Basic for Applications (VBA) can seem antiquated for many programmers, it is highly relevant for many workplaces. Countless office environments still rely on the Microsoft Office suite. Those offices likely do not have significant developer skills readily available. More often than not, people don’t know what is possible with the tools they have readily available.
There are tremendous opportunities to help in this domain. Automating tasks and processes saves time, reduces errors inherent in manual operations, and increases work capacity.
Whether its tools for my job, teammates or others (technical and non-technical), developing tools and applications have facilitated saving my clients hundreds to thousands of hours every year. This is a force multiplier. Sometimes people just need a little something to boost productivity by automating a particular menial or mundane task at work. When a task is done daily or even multiple times a day, it can add up. These savings in time, translate to costs. Recovered time can be focused on other areas still requiring manual effort.
Topics to Cover:
- Consolidating columns
- Creating distinct lists and frequency distributions
- Post Pending
- Horizontal and Vertical demerging
- Format decomposition
- Creating user defined functions
- Optimizing your code for significantly faster run-times
- Creating customized ribbons
- Building user interfaces for data entry
- Dependent drop-down menus
This is not an all-encompassing list. It should help give you an idea of some of the tasks I’ll work through.