Keyboard Shortcuts are the key to working efficiently in Excel. Unfortunately, many modern laptops are too small to have a full-sized keyboard, making it harder to use keyboard shortcuts. There are several common keyboard layout shortcomings that are especially limiting: A fn key directly to the left of the CTRL key on the bottom-left of… Continue Reading
So you’re building a spreadsheet that requires the user to enter a ZipCode, City, and State… How do you build a smarter spreadsheet that automatically fills in the City and State after the user inputs only the ZipCode? I’ve been looking at some basic tutorials that web devolopers are using with XMLHttpRequest, like this one,… Continue Reading
This tutorial will explain what a reference is and how to use them in the VBA Editor If you are working in Excel VBA, and you wish to work with Objects available in a different application – like Microsoft Word for example, you need to add a reference to the object library of that application.… Continue Reading
AutoMacro: VBA Code Indenter, Formatter, Cleaner, and More VBA Coding Tools and Utilities AutoMacro has been used by employees of these organizations. These organizations do not endorse, approve, sponsor, or otherwise have any affiliation with this website, Spreadsheet Boot Camp LLC, or ToolFive Software LLC. Online VBA Code Formatter To quickly indent VBA Code, check… Continue Reading