Introduction to Visual Basic for Applications (VBA) in Excel

Visual Basic for Applications can be used to extend the capabilities of Excel with custom calculations. Microsoft Excel itself is not a programming language but does include an integrated development environment for recording and running macros (VBA environment). Excel macros are a series of commands that can be repeated to operate repeatedly on sets of data.

Below is an example problem that demonstrates whether a tank of particular dimensions will overflow with a certain amount of time. The tutorial shows how to import data from the worksheet, perform volume calculations, determine whether the tank will overflow with an IF statement, print out a message box, and export the volume values to the active worksheet.

This same example problem is also demonstrated with MATLAB and in the Python programming language

Course Information

Excel and VBA

Python

MATLAB

MathCAD

Related Courses

Admin

Streaming Chatbot
💬