fbpx

VBA Courses

VBA or Visual Basic for Applications is a programming language that is used to automate tasks in Microsoft Office Applications. SpiralTrain provides classroom VBA training for Word, Excel and Access. SpiralTrain also provides advanced and customized training in VBA on request. Visit our LinkedIn, Facebook or Instagram page for an impression of SpiralTrain. Click on the links below for more information about the courses and the schedule.

VBA Course List

Course VBA Access Programming
Course Access Programming with VBA
Code: VBA100
First start: 25-04-2024
2 days € 1299
Course Excel Programming with VBA
Course Excel Programming with VBA
Code: VBA200
First start: 02-05-2024
2 days € 1299
Course Word Programming with Word
Course Word Programming with VBA
Code: VBA300
First start: 11-04-2024
2 days € 1299

VBA versus Visual Basic

Visual Basic for Applications (VBA) is an implementation of Microsoft’s event-driven programming language Visual Basic. Although Visual Basic is no longer updated by Microsoft, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office applications.

Replacement of Macro’s

Visual Basic for Applications enables building user-defined functions automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word’s Word BASIC. It is used to control many aspects of the host application, including manipulating menus and toolbars, and working with custom user forms or dialog boxes.

Office Integration

VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library. However, VBA code normally can only run within the host application and not as a standalone program. VBA can, however, control one application from another using OLE Automation. For example, VBA can automatically create a Microsoft Word report from Microsoft Excel data that Excel collects automatically from polled sensors. VBA can use, but not create, ActiveX/COM DLLs, and later versions add support for class modules.