There are a multitude of online resources to help you develop your Visual Basic for Applications (VBA) skills. Here are a few core links, referenced in Beezix’s VBA 2016 Introduction quick reference guide, that will enhance any VBA project you take on.
Updated to include macOS Mojave. Most searches on your Mac can be done quickly and easily by clicking and typing either the name of or a word contained within the file you need. Sometimes, though, a more refined search is necessary....
It’s common for multiple users to share the same computer, both in business and home environments. Creating a separate user account for each user can help keep documents, settings, and information separate.
Excel features a special format for dates. Unfortunately, some people find out about how Excel formats dates only after dates hadn’t been entered properly. Perhaps an invoice gets sent out on December 1 instead of January 12 because the day and month were reversed. Or maybe you can’t sort that data you collected because the dates weren’t entered properly.
Changing your operating system’s regional settings — whether it’s a PC or Mac — allows you to see and enter dates in a way that is familiar to you. In Excel, for instance, entering dates will be different based on the regional settings.