Basic VBA Macros in Microsoft Excel is a beginner course in automating Excel with VBA, from recording macros and editing code to variables, conditions, loops, the Excel object model, events and UserForms, through to working with table data and handling errors. It suits data staff and confident Excel users, and you leave able to build a one-click reporting macro.
Many Excel tasks are repeated every day or every month: opening a text file exported from a database system, filling in blank cells, filtering and sorting, copying between files, then summarising with a PivotTable and printing only the records you need. Doing this by hand takes time and steps are easily missed. Macros written in VBA combine these steps so they finish in one click, and VBA remains the main automation tool for Excel on the desktop in Microsoft 365.
This course starts with recording macros, setting macro security and running macros from buttons or shortcut keys. You then read and edit code in the VBA Editor, write subs and functions, use variables, conditions and loops, work with workbooks, worksheets and ranges, write event code, build ways to collect input with MsgBox, InputBox and UserForms, manage data in Excel tables, import and clean CSV data, handle errors and debug code. It finishes with a workshop that builds a one-click reporting system. (5 days, 6 hours per day, 30 hours in total, Beginner level.)
Course Details
This is the 2026 edition of the Basic VBA macros in Microsoft Excel course. It runs for 5 days, 6 hours per day (30 hours in total, 09:00-16:00), as lectures with hands-on coding labs in every topic, at Beginner level. The content has been updated for Excel in Microsoft 365 and Excel 2024, adding the changed macro security defaults, Trusted Locations, working with Excel
tables and CSV files, and guidance on when Power Query or Office Scripts suit better than VBA. It is an entry-level course, distinct from Excel with VBA and Advanced VBA macros in Microsoft Excel, which go on to more complex work. Learners use their own or their company's Excel for Windows and take home the course handbook, practice files, sample code and the reporting system from the workshop.
Section 1: Macros and VBA in Today's Excel
Section 2: Lab: Recording Macros
Section 3: Lab: Macro Security
Section 4: Lab: Running Macros
Section 5: Lab: The VBA Editor and Recorded Code
Section 6: Lab: Modules, Subs and Functions
Section 7: Lab: Variables and Data Types
Section 8: Lab: Conditional Statements
Section 9: Lab: Loops
Section 10: Lab: The Excel Object Model
Section 11: Lab: Range Properties and Methods
Section 12: Lab: Managing Sheets and Multiple Files
Section 13: Lab: Workbook and Worksheet Events
Section 14: Lab: MsgBox and InputBox
Section 15: Lab: UserForm Basics
Section 16: Lab: VBA with Excel Tables
Section 17: Lab: Importing and Cleaning CSV Data
Section 18: Lab: Handling Errors
Section 19: Lab: Debugging Code
Section 20: Workshop: A One-Click Reporting System
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
On the Developer tab, click Record Macro, give it a name and choose where to store it, carry out the steps, then click Stop Recording. Press Alt+F11 to open the VBA Editor, where the code sits in a module of that workbook and can be edited straight away, for example by removing unnecessary Select statements or replacing fixed ranges with code that finds the data area. Save the file as .xlsm to keep the macro.
If checks a condition and chooses what to do, for example colouring sales green when they beat the target. For Each repeats an action for every member of a collection, such as every cell in a range or every sheet in a workbook. Together they let you check data cell by cell and act only on the cells that match. Declare variables with Dim and use Option Explicit to reduce mistakes.
Go to File, Options, Trust Center and Trust Center Settings. The recommended setting is to disable macros with notification, then add the folders that hold your work macro files as Trusted Locations. Macros in files downloaded from the internet or received by email are blocked by default, so enable only files from sources you trust. In organisations, administrators may already control these settings.
It suits data staff, IT staff and employees who are confident in Excel and want to cut repetitive work. You do not need programming experience, but you should be able to use Data tab commands, Conditional Formatting, PivotTables and formulas such as IF, XLOOKUP, COUNTIFS and SUMIFS, and bring a Windows laptop with Excel from Microsoft 365 or Excel 2024.
You will be able to record and edit macros, set macro security, write subs and functions with variables, conditions and loops, control workbooks, worksheets and ranges in code, write event code, build UserForms, manage data in Excel tables and CSV files, handle errors and build a one-click reporting system. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.
Yes. It can be run in-house for your team, with examples adapted to your own work, such as your system exports, monthly reports or the forms you actually use. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
Articles are published in Thai.
Many organisations start keeping data in Excel because it is easy, but as the data grows and more people need it, they run into duplicates, inconsistent entries, several versions of the same file and reports that have to be compiled by hand every month.…
Once you can write basic macros, real work soon gets harder. Data runs to tens of thousands of rows, so macros that loop cell by cell become slow; files have to be combined from many folders; totals must be summarised by unique customer code; PivotTables and…
Excel is used in almost every job, from keeping lists and working out expenses to summarising monthly sales, yet many users still retype figures by hand, copy formulas that give wrong results or spend too long setting up pages for printing. Getting the…
