
Excel VBA tutorials
What is VBA in excel?
VBA, or Visual Basic for Applications, is the programming language tool for Microsoft in Excel and all other Office suite programs. Although Excel provides a large number of tools with which to operate, VBA allows expansion in the range of tools available to the user.
Why is Excel VBA important?
Users can work with VBA to write their own functions and commands, helping not only to simplify their Excel experience, but also to expand the level of functionality available to them. This is important as although there is a wealth of tools at the disposal of the Excel user, there is often need for a more tailored program.
VBA permits the user to develop and test a program which can then be used within Microsoft Excel. Once a program is created, one can execute the command with a macro. This is extremely useful for simplifying a number of regular tasks that the user may have otherwise spent a significant period of time performing. This programming language built into the Microsoft suite is therefore extremely beneficial to the user, especially if time is at a premium.
What is the difference between VBA and Macro?
It is necessary to understand that there is a difference between VBA and Macro. Macro is the older and less powerful language that was used by Microsoft Office suite. It could, however, only be used for automating instructions. VBA, on the other hand, has a range of functions which allow users more autonomy in their experience of Excel.
What are some of the common uses for Excel VBA?
Inserting a text string: You can develop a VBA program to create a macro that automatically inserts the text that you want. This can be useful when you have long lists of text, i.e. a list of employees, that need inserting on numerous occasions.
Automating a commonly performed task: This can be very useful for creating things such as sales reports, allowing a quick and easy way to reproduce the reports with the VBA program doing the work for you.
Automating repetitive actions: VBA can record the sequence of Excel commands that you use and then play it back in the form of a macro. This is particularly useful if you have to perform the same tasks on multiple workbooks.
Creating a custom command: VBA can also help create a macro that combines the sequence of commands that are commonly used.
Creating a custom menu command: This allows the user to customise Excel's menus with your own commands, executing macros as you write.
Developing new worksheet functions: Excel has numerous already programmed functions, such as SUM, however VBA allows you to add to these, creating your own custom worksheet functions.
If you would like to find out more about VBA within Excel and its uses, please refer to the website links below:
Most popular tutorials
- Shades all inter-sheet links with RED (Links-out) or BLUE (Links-in) in the whole workbook.1,440Discussadd_shopping_cart$10.00
by Anurag Kushwaha
An Introduction to VBA Course
This course will help you understand the fundamentals of VBA so you can program all by yourself.440Discussadd_shopping_cart$150.00by Marcus Small
Excel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!398Discussadd_shopping_cart$39.99by CFA
Controlling Outlook from Excel (full version)
Explains how to programmatically link Excel to Outlook182Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Compare Two Excel Worksheets and Find Matches and Differences
Compare Two Excel Worksheets and Find Matches and Differences, this could be the ultimate tool you are looking!497Discussadd_shopping_cart$15.00by ExActProBi
Bulk IP to Country Excel converter
Easy to use Excel converter to determine countries for a bulk list of IP addresses.164Discussadd_shopping_cart$10.00by Tejasvita Soni
VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface207Discussadd_shopping_cart$25.00by Andrei Okhlopkov
Dynamic Graphing in Excel (UNLOCKED)
Excel graphs that update and re-scale upon Pivot Table slicer click(s)94Discussadd_shopping_cart$19.00by ExcelModels
Productivity VBA tool - Automation of year on year movement computation for multiple periods
A VBA Macro for automatic year on year movements and automatic formatting.235Discussadd_shopping_cartfreeby HEURTEBIZE
Comparable Companies (NON-FDS) Excel Model
A full Excel valuation model template comparing companies1,430Discussadd_shopping_cartfreeby John P. Burns
Fluid Flow Excel Workbook
Excel Workbook aligning with Chapter 4: 'Fluid Flow' in the textbook "Rules of Thumb for Chemical Engineers."633Discussadd_shopping_cartfreeby Stephen Hall
Process Modeling Excel Workbook
Workbook in Excel illustrating techniques- using VBA subroutines- for incorporating input data into a process model.467Discussadd_shopping_cartfreeby Stephen Hall
Physical Properties Excel Workbook
Physical Properties workbook to calculate steam & water thermodynamic properties.362Discussadd_shopping_cartfreeby Stephen Hall
Free Multi-purpose Excel Modelling Tool (Add-in)
Free Microsoft Excel modelling add-in containing a wide range of tools for navigation, formatting and excel modelling.2,7421add_shopping_cartfreeby Kevin Yassine
FIFA World Cup 18 - Monte Carlo Simulation Model
FIFA World Cup 18 Monte Carlo Simulation Model1,0922add_shopping_cartFinancial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.1,344Discussadd_shopping_cart$15.00by Prof. Ed Bodmer
priced tutorials
Excel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!398Discussadd_shopping_cart$39.99by CFA
Export/Import Add-in (for financial models)
Shades all inter-sheet links with RED (Links-out) or BLUE (Links-in) in the whole workbook.1,440Discussadd_shopping_cart$10.00by Anurag Kushwaha
Financial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.1,344Discussadd_shopping_cart$15.00by Prof. Ed Bodmer
An Introduction to VBA Course
This course will help you understand the fundamentals of VBA so you can program all by yourself.440Discussadd_shopping_cart$150.00by Marcus Small
Controlling Outlook from Excel (full version)
Explains how to programmatically link Excel to Outlook182Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Compare Two Excel Worksheets and Find Matches and Differences
Compare Two Excel Worksheets and Find Matches and Differences, this could be the ultimate tool you are looking!497Discussadd_shopping_cart$15.00by ExActProBi
Bulk IP to Country Excel converter
Easy to use Excel converter to determine countries for a bulk list of IP addresses.164Discussadd_shopping_cart$10.00by Tejasvita Soni
VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface207Discussadd_shopping_cart$25.00by Andrei Okhlopkov
Dynamic Graphing in Excel (UNLOCKED)
Excel graphs that update and re-scale upon Pivot Table slicer click(s)94Discussadd_shopping_cart$19.00by ExcelModels
Control of Bets and Balances for Playing Cards Excel Model
This Excel file provides the solution for controlling bets and balances for card games such as poker.50Discussadd_shopping_cart$10.00by Pissolato
Client Control for Lawyers Excel Model
This Excel file brings the solution to Client Control for Lawyers.64Discussadd_shopping_cart$10.00by Pissolato
Parking Control Excel Model
This Excel file brings the solution to Parking control.75Discussadd_shopping_cart$10.00by Pissolato
Event Table Allocator
Tool to support table allocation for the event organizers.41Discussadd_shopping_cart$9.50by Samir Asadov CFA
Excel Benchmark tool
Test the power of your device core-processor to run Excel models90Discussadd_shopping_cart$5.00by Jack Avon
Newly published
Automatic Email Sending (with attachments) Excel VBA/Macro Template
Send Multiple Emails Automatically to Customers with File attachments via EXCEL & OUTLOOK. VBA MACRO10Discussadd_shopping_cartVBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface207Discussadd_shopping_cart$25.00by Andrei Okhlopkov
VBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface893Discussadd_shopping_cartfreeby Andrei Okhlopkov
Copy Outlook eMail to a local folder
The video will explain how to setup a macro in Outlook to copy an email to a local folder.31Discussadd_shopping_cartControlling Outlook from Excel (full version)
Explains how to programmatically link Excel to Outlook182Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Download Financial Market Time Series Data
Download and align Open, High, Low, Close and Volume stock and index data for multiple symbols and time frequencies.329Discussadd_shopping_cartOutlook - VBA Automatic E-Mails Sending from Excel
Send Automatic E-Mails from Excel with Outlook - VBA63Discussadd_shopping_cartfreeby Rafael Buzin
Event Table Allocator
Tool to support table allocation for the event organizers.41Discussadd_shopping_cart$9.50by Samir Asadov CFA
Let it snow! Excel@Christmas
Let it snow in Excel!157Discussadd_shopping_cartfreeby Gary Knott
De-select Active Cell from a selection with a VBA Macro
De-select a cell from a collection of selected cells/ranges in an Excel worksheet1491add_shopping_cartfreeby Michael Martin
Excel Benchmark tool
Test the power of your device core-processor to run Excel models90Discussadd_shopping_cart$5.00by Jack Avon
Financial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.1,344Discussadd_shopping_cart$15.00by Prof. Ed Bodmer
Export/Import Add-in (for financial models)
Shades all inter-sheet links with RED (Links-out) or BLUE (Links-in) in the whole workbook.1,440Discussadd_shopping_cart$10.00by Anurag Kushwaha
ECB foreign exchange rates Excel Model
Download ECB Rates at a click of a button250Discussadd_shopping_cartExcel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!398Discussadd_shopping_cart$39.99by CFA
Master the VBA Editor!
Learn how to use the VBA editor *PROPERLY* ....and you'll save more time than you ever thought possible...!425Discussadd_shopping_cartfreeby CFA
Full catalog
ECB foreign exchange rates Excel Model
Download ECB Rates at a click of a button250Discussadd_shopping_cartExcel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!398Discussadd_shopping_cart$39.99by CFA
Dynamic Graphing in Excel (DEMO)
Excel graphs that update and re-scale upon Pivot Table slicer click(s)325Discussadd_shopping_cartfreeby ExcelModels
Batch PDF Data Extraction
Extract text and data from multiple PDF files into structured tabular format based on start and end pattern matching.366Discussadd_shopping_cartProductivity VBA tool - Automation of year on year movement computation for multiple periods
A VBA Macro for automatic year on year movements and automatic formatting.235Discussadd_shopping_cartfreeby HEURTEBIZE
Free Multi-purpose Excel Modelling Tool (Add-in)
Free Microsoft Excel modelling add-in containing a wide range of tools for navigation, formatting and excel modelling.2,7421add_shopping_cartfreeby Kevin Yassine
FIFA World Cup 18 - Monte Carlo Simulation Model
FIFA World Cup 18 Monte Carlo Simulation Model1,0922add_shopping_cartDownload Financial Market Time Series Data
Download and align Open, High, Low, Close and Volume stock and index data for multiple symbols and time frequencies.329Discussadd_shopping_cartMaster the VBA Editor!
Learn how to use the VBA editor *PROPERLY* ....and you'll save more time than you ever thought possible...!425Discussadd_shopping_cartfreeby CFA
Comparable Companies (NON-FDS) Excel Model
A full Excel valuation model template comparing companies1,430Discussadd_shopping_cartfreeby John P. Burns
Basic Simulator in Excel - Piston Engine
This is the most basic simulator model of a piston engine built on Excel VBA Framework.657Discussadd_shopping_cartfreeby Kamal C Bharakhda
Let it snow! Excel@Christmas
Let it snow in Excel!157Discussadd_shopping_cartfreeby Gary Knott
Management Data Entry
Excel Data Entry User Form made with Visual Basic.8731add_shopping_cartfreeby Rilinda Abazi
Fluid Flow Excel Workbook
Excel Workbook aligning with Chapter 4: 'Fluid Flow' in the textbook "Rules of Thumb for Chemical Engineers."633Discussadd_shopping_cartfreeby Stephen Hall
VBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface893Discussadd_shopping_cartfreeby Andrei Okhlopkov
Export/Import Add-in (for financial models)
Shades all inter-sheet links with RED (Links-out) or BLUE (Links-in) in the whole workbook.1,440Discussadd_shopping_cart$10.00by Anurag Kushwaha
- Have a Excel VBA Tutorial to Share?
Your Excel VBA Tutorial
Publish your Tutorial
Learn more about digital publishing