
Excel VBA tutorials Start the discussion!

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,534Discussadd_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.470Discussadd_shopping_cart$150.00by Marcus Small
Excel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!448Discussadd_shopping_cart$39.99by CFA
Controlling Outlook from Excel (full version)
Connecting Excel to Outlook programmatically263Discussadd_shopping_cart$25.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!596Discussadd_shopping_cart$15.00by ExActProBi
Dynamic Graphing in Excel (UNLOCKED)
Excel graphs that update and re-scale upon Pivot Table slicer click(s)112Discussadd_shopping_cart$19.00by ExcelModels
Bulk IP to Country Excel converter
Easy to use Excel converter to determine countries for a bulk list of IP addresses.192Discussadd_shopping_cart$10.00by Soni Excel Solutions
VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface227Discussadd_shopping_cart$25.00by Andrei Okhlopkov
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.284Discussadd_shopping_cartfreeby HEURTEBIZE
Comparable Companies (NON-FDS) Excel Model
A full Excel valuation model template comparing companies1,507Discussadd_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."712Discussadd_shopping_cartfreeby Stephen Hall
Process Modeling Excel Workbook
Workbook in Excel illustrating techniques- using VBA subroutines- for incorporating input data into a process model.502Discussadd_shopping_cartfreeby Stephen Hall
Physical Properties Excel Workbook
Physical Properties workbook to calculate steam & water thermodynamic properties.385Discussadd_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,8701add_shopping_cartfreeby Kevin Yassine
FIFA World Cup 18 - Monte Carlo Simulation Model
FIFA World Cup 18 Monte Carlo Simulation Model1,1382add_shopping_cartFinancial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.1,380Discussadd_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!448Discussadd_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,534Discussadd_shopping_cart$10.00by Anurag Kushwaha
Financial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.1,380Discussadd_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.470Discussadd_shopping_cart$150.00by Marcus Small
Controlling Outlook from Excel (full version)
Connecting Excel to Outlook programmatically263Discussadd_shopping_cart$25.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!596Discussadd_shopping_cart$15.00by ExActProBi
Dynamic Graphing in Excel (UNLOCKED)
Excel graphs that update and re-scale upon Pivot Table slicer click(s)112Discussadd_shopping_cart$19.00by ExcelModels
Bulk IP to Country Excel converter
Easy to use Excel converter to determine countries for a bulk list of IP addresses.192Discussadd_shopping_cart$10.00by Soni Excel Solutions
VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface227Discussadd_shopping_cart$25.00by Andrei Okhlopkov
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.65Discussadd_shopping_cart$10.00by Pissolato
Client Control for Lawyers Excel Model
This Excel file brings the solution to Client Control for Lawyers.75Discussadd_shopping_cart$10.00by Pissolato
Parking Control Excel Model
This Excel file brings the solution to Parking control.98Discussadd_shopping_cart$10.00by Pissolato
Event Table Allocator
Tool to support table allocation for the event organizers.56Discussadd_shopping_cart$5.00by Samir Asadov CFA
Excel Benchmark tool
Test the power of your device core-processor to run Excel models118Discussadd_shopping_cart$5.00by Jack Avon
Newly published
Controlling Outlook from Excel (full version)
Connecting Excel to Outlook programmatically263Discussadd_shopping_cart$25.00by Andrei Okhlopkov
Check If You Can Run Excel Macros on Your Computer
Check that Matching_Items_from_Overlapping_Lists will work on your computer.21Discussadd_shopping_cartfreeby Matterwise LLP
Automatic Email Sending (with attachments) Excel VBA/Macro Template
Send Multiple Emails Automatically to Customers with File attachments via EXCEL & OUTLOOK. VBA MACRO102Discussadd_shopping_cartVBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface227Discussadd_shopping_cart$25.00by Andrei Okhlopkov
VBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface925Discussadd_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.44Discussadd_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.377Discussadd_shopping_cartOutlook - VBA Automatic E-Mails Sending from Excel
Send Automatic E-Mails from Excel with Outlook - VBA80Discussadd_shopping_cartfreeby Rafael Buzin
Event Table Allocator
Tool to support table allocation for the event organizers.56Discussadd_shopping_cart$5.00by Samir Asadov CFA
Let it snow! Excel@Christmas
Let it snow in Excel!180Discussadd_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 worksheet1761add_shopping_cartfreeby Michael Martin
Excel Benchmark tool
Test the power of your device core-processor to run Excel models118Discussadd_shopping_cart$5.00by Jack Avon
Financial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.1,380Discussadd_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,534Discussadd_shopping_cart$10.00by Anurag Kushwaha
ECB foreign exchange rates Excel Model
Download ECB Rates at a click of a button307Discussadd_shopping_cartExcel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!448Discussadd_shopping_cart$39.99by CFA
Full catalog
ECB foreign exchange rates Excel Model
Download ECB Rates at a click of a button307Discussadd_shopping_cartExcel VBA for Financial Modeling | Excel Automation
Learn VBA to Automate Excel by building SEVEN time-saving tools!448Discussadd_shopping_cart$39.99by CFA
Dynamic Graphing in Excel (DEMO)
Excel graphs that update and re-scale upon Pivot Table slicer click(s)356Discussadd_shopping_cartfreeby ExcelModels
FIFA World Cup 18 - Monte Carlo Simulation Model
FIFA World Cup 18 Monte Carlo Simulation Model1,1382add_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.284Discussadd_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,8701add_shopping_cartfreeby Kevin Yassine
Batch PDF Data Extraction
Extract text and data from multiple PDF files into structured tabular format based on start and end pattern matching.500Discussadd_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.377Discussadd_shopping_cartMaster the VBA Editor!
Learn how to use the VBA editor *PROPERLY* ....and you'll save more time than you ever thought possible...!458Discussadd_shopping_cartfreeby CFA
Automatic Email Sending (with attachments) Excel VBA/Macro Template
Send Multiple Emails Automatically to Customers with File attachments via EXCEL & OUTLOOK. VBA MACRO102Discussadd_shopping_cartComparable Companies (NON-FDS) Excel Model
A full Excel valuation model template comparing companies1,507Discussadd_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.775Discussadd_shopping_cartfreeby Kamal C Bharakhda
Let it snow! Excel@Christmas
Let it snow in Excel!180Discussadd_shopping_cartfreeby Gary Knott
Management Data Entry
Excel Data Entry User Form made with Visual Basic.1,0021add_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."712Discussadd_shopping_cartfreeby Stephen Hall
VBA Interface Collection (demo version)
A set of Excel VBA macros aimed at enhancing user interface925Discussadd_shopping_cartfreeby Andrei Okhlopkov
- Have a Excel VBA Tutorial to Share?
Your Excel VBA Tutorial
Publish your Tutorial
Learn more about digital publishing