I have a template with a VBA UserForm. When the userform is loaded and the user goes to move the userform sideways on their screen to see some data in their document, it leaves a shadow/tail of its path. See image below.
I have code in the initialization of the form to stop screen updating, eg
Application.ScreenUpdating = False
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.