a_number_processing.bas contains Visual Basic code that can be used as a macro in Excel for replacing A-numbers with UIDs. Assuming that the macro has been imported, or is otherwise available (see ...

Automate Table of Contents in Excel VBA is a program that generates a table of contents for an Excel workbook using VBA macros. This program eliminates the need for manually creating and updating the ...

In this VBA for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you ...

Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...

These are the demonstration files to accompany the article, How to run a VBA procedure from a data validation control in Microsoft Excel by Susan Harkins. This download includes an Excel file and a ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.