Oct 28, 2013
Although Excel has 350+ functions built-in, you can use VBA to build your own custom functions. A couple of months ago, I delivered a 1-hour live online training session called VBA 101. It was a gentle introduction to VBA in Excel – what it is, how it can be...
Nov 19, 2012
Last week a customer sent me an Excel file which was set up as a basic form to capture information. As you can see from the screenshot below, the purpose of the form was to capture information about product complaints. The height of Row 8 had been increased and B8 was...
