VBA

Tips of the Trade

On this page you will find tips on how to create your own macros using VBA. Note, programs in VBA are also called macros. These tips will be based in Microsoft Excel but like we said above, macros can be created for other Office applications.

Visual Basic for Applications (VBA) is a programming language developed by Microsoft that is included in several Microsoft Office applications, including Excel. VBA is used to create programs which perform one or more tasks in the application. It is what we use to build our SheetsFreaks games.

Contact us If you have questions or would like us to post on specific VBA topics.

Topics

Getting Started with VBA

Where to go to start programming in VBA.

Running VBA macros

These are the three methods I typically use to run my VBA macros.

Using VBA to Create Charts in Excel

This Microsoft Excel macro creates charts/graphs for each column of data on a worksheet.

Using VBA to Copy Charts from Excel to PowerPoint

This Microsoft Excel macro copies charts/graphs from a worksheet and pastes them into a Microsoft PowerPoint presentation.

Using VBA to Send Emails from Excel through Outlook

This Microsoft Excel macro sends emails through Microsoft Outlook using values from the spreadsheet.

Using VBA to Pull Data From Every Workbook in a Folder

This Microsoft Excel macro gets data from every workbook in a single folder and brings it into a master spreadsheet.