Excel VBA Coding, Macro Recording Examples Free Download

Excel VBA, the sock behind your data

If you are still convinced that Excel is that safe and boring cousin of a spreadsheet program where rows and columns merely merge, think again. In a nutshell , you’ve been caught napping. What you use and depend upon is Visual Basic for application or vba, the master key that transforms this common office application into a magic wand your fingers can wield. So whats this sorcery all about? Well for starters, Vba is a programming language that holds the key to manipulate Microsoft Excel like a master. It’s how you tell the program to do this, do that again or send you an email alert when a certain cell turns red. Performing mundane tasks automatically, solving complex calculations in milliseconds, creating boutique reporting systems are all easily achieved by you. The crux of the story isn’t the spell you have at hand but how you choose to control it.

I feel that scripting is the most direct form that exists of creating a concept in a software universe. What’s more about transforming a dull problem statement into logical little bites and making those portions communicate with each other. Imagine the last day of any period and you need to prepare a sales report lying over your cup of coffee. With VBA your script loads the data, iterates the calculations, generates all graphical reports and sends the e-mail to your boss before you even have your first sip.

Yes …! but this ability also has its own shortcomings and the lesson is patience and analytical thinking. I remember staring at a blank screen when I wrote my first program script. I have pulled my hair in anguish over logic errors for endless nights. But in the long run, you finally start to communicate in that machine’s language and the experience one gets develops problem solving skills with keenness of tempered steel.

So far, you might be wondering why in 2026 we still play with VBA when Python is all around. But the truth, as seen from one too many instances is that not only Excel is ubiquitous but the automation tool under Microsoft’s analytical umbrella, dominates the field without causing disruption in your work station. No need to worry about compatibility or additional installations, the VBA is with you the moment you open a spreadsheet.

That said , it’s a fact that VBA is not the ideal tool for all sorts of analysis or massive data sizes. Nor is it suitable for web based application development. Given that it really excels for fast practical execution that work directly within Excel’s own veins. My final point is that programming can never be about stacking commands one on top another as all software programming needs a lot more of unique creativity. A finance colleague of mine used to prepare weekly reports manually, it whined and whined about the boring process. I put together a simple fifty line script and speeded up his workload to three minutes from two hours.

Now that is an true elegance o input smarts. For me, vba gives you back your time by removing all the dull tedium from your mind so that you can set about the strategic thinking in earnest. When the music is of data, this language puts you up front and center.

Where to start your VBA exploits in MS Excel ?

In the introductory paragraph I mentioned MS Excel as the cockpit where you bowl the space shuttle. But it turns out that it’s no more complicated than with that highly expensive chef’s knife for you not to cut your fingers unecessarily. The first thing to do is to get your Developer tab onto the stage. All you need is to go via File, Options and Customise Ribbon. Just ensure that in the pane on the right, you have clicked on the check box that reads Developer. Now you have unlocked the backyard of Excel to become your trainer. Too many times I have seen how people never get to use this powerful bit but just because they coughed up on this step. The Visual Basic button is the speedway to get to the author’s room.

Using the macro recorder is like having training wheels on your bike, a brilliant invention to learn control. However, be vigilant because the recorder tells you what you’ve done , not how you think. For example, if while recording, you select a column and make it bold, you will see a specific font bolding line of code. This is invaluable for understanding how VBA operates with objects.

In my opinion, true knowledge is acquired when you apply logic to the raw material. For example with a little tinkering and you could adapt the code to define a table in a variable so that the table range is dynamic and adapts to the size of your dataset.

The little red hat with that golden plaque that says Alt+F11 is what will open your Visual Basic Editor. Start a new module, it’s where your tools go in. Now create your first Sub command. Start small for instance you might create a simple command that makes a message string. Put it on a form button and hit the command. Ohhh … the satisfaction of knowing that the command is like flipping a light switch and being part of a circuit of your own. Fantastic ! But a word of warning, avoid the temptation of searching for ready commands on the Internet. Remember , a winner in the racing circuit is the one who knows all about the failures that have led him or her to the top position.

Looking for a home for the modules and code

The gray black hole that you first see when you open the editor might be a shock. But just think of it as your own white room where you are free to combine lego pieces at random. When you open the editor you will see a tree structure on left of the screen. Modules are the well-organized compartments for your tools. In the beginning I have seen the mistakes of throwing all the code into workbook or sheet like repositories. The right way is to right click, insert and select module. Create logical modules. For example create a module for finance calculations and keep related functions in one place. Otherwise your work will lead you to nowhere.

Another difference you should understand is the Sub and Function. The action, such as changing the background color of a cell or deleting rows is performed by a Sub. The calculation and returning of a value is done by a Function just like SUM function in Excel.

Also do not forget the difference of the Public and Private. If you want to invoke Macro using Button on your Excel ribbon, then the subroutine must be a Public one. Using Private for helper functions is the cornerstone for elegant and safe code. People who ignore these simple details will usually be tearfully disappointed when their macros do not appear in the list and they click panic. Then is the IntelliSense. When you type the object and add a dot, it will give every property possible on the list. It protects you from some common typos in the syntax and also serves as helpful reminder. But do not fully rely on the utility.

Everything is crystal clear when you press F5 to run your code. Either your lines of code will resemble a flow of poetry or you face with errors. Remember the modules are for your code. You cannot learn much by going through the cluttered house. Grouping functions, finding descriptive names and always adding comments with a quote is highly recommended. After a decade of experience I can confidently say that the code now looks like a language forgotten in half a year.

Making the Macro Recorder your own Co Pilot

The macro recorder is your own digital stenographer that diligently records every action you take. Hit record from the developer tab whenever you want your own digital aide. But beware, the macro recorder defaults to absolute references. If you turn on the recorder, click cell a1, then the macro will always go to cell a1, no matter where you move the cursor. Absolute references are the number one rookie mistake. To avoid the consequences hit the use relative references button. Your macro then assembles the code using variable points of origin and is more flexible.

The code created by the recorder is typically verbose. It can’t do loops or if then statements by itself. If you want to scan hundreds of rows and delete the blank ones, you need to take over. A colleague in bookkeeping announced, the macro recorder gives you the ingredients, but you still need to know how to hold the fork and sprinkle salt.

How to Refactor and make sense of your Raw Recorder code

The code from the recorder tends to be lengthy and sometimes redundant. Taming this beast takes a true chef. Rule number one, eliminate all Select and Selection commands. The recorder is overprone to select a cell then act on it. Too inefficient. Instead, write the same command and directly point to the range. Performance can jump up by 40% and that was from only one change and the flickering stopped.

The second rule is to establish your variables. Dim everything. VBA catches everything you type as type variant which hogs memory. Use Long for numbers, as most versions of excel now exceed the integer binary limit.

The third rule is to use With blocks. If you will do three or four things to one cell, put them all together. That triple rule will improve your code readability by sixty percent. Last rule, clean out the excess rounds the recorder adds to the gun when it switches into copy mode and then back. Do less and get further.

How VBA is integrated into your Excel software

If someone is wondering the answer is no. You will never have to consider installing Excel VBA from somewhere else because Microsoft has integrated it into the DNA of the Excel framework. Thanks to this plug and play approach, you can develop your solutions without dealing with IT bureaucracy. Sadly though, this makes things easier and the flip side of this coin is that Excel permits the existence of macro malware. Therefore, Excel won’t allow you to run any bad macros it detects until you give it an approval. Although finance professionals are lately overly focused on macro security, they will never trade the quickness and the power of vba for local files. The wave of cloud-based softwares accelerates but at the moment, vba remains the sleeping giant engine waiting in the corner to be unleashed on your machine.

What are the main advantages of mastering Vba for Excel in today’s environment ?

There is a smile every time I hear most VBA skeptics expecting to focus away from macros in the future. Power Query and Python are nice, but if you want to customize the Excel interface, call up up custom user forms or get some automation triggered on the screen when you open a file, there is no alternative. Over a developer career, people who know VBA will be amongst the best paid Excel users. Not even speaking about the time accounting and finance departments spend in MS Excel, very few of them are able to control and wield the software.

In today’s workplace, everybody wants reports made yesterday and there are no months to learn a new coding language. With vba, you can change your own habits in just two days. It is hard to underestimate the rise of artificial intelligence but we often forget that simple codes take seconds to generate and ai can’t match human wit when it comes to blending complex business logic. Excel has a billion users worldwide and as a knowledge worker, learning VBA makes you irreplaceable. If you are no longer just a user of Excel but an architect of it, the stage is yours.

DOWNLOADS

1. Assigning Values and Formatting Cells Code

Sub EditCell()
    Range("A1").Value = "Hello World"     ' Write text to cell A1
    Range("A1").Font.Bold = True          ' Bold the text
    Range("A1").Interior.Color = RGB(255, 255, 0) ' Set background to yellow
    Range("A1").HorizontalAlignment = xlCenter    ' Center-align text
End Sub

What Does It Do?
Writes Hello World to cell A1 applies bold formatting yellow background and centers the text.

2. Macro Recorder-Generated Example Code

Sub RecordMacro()
    Range("B2").Select
    ActiveCell.FormulaR1C1 = "=RAND()"    ' Generate a random number
    Range("B2").Copy
    Range("C2").PasteSpecial Paste:=xlPasteValues ' Paste as value
End Sub

What Does It Do?
A basic macro-generated code Adds a random number to B2 and pastes the value to C2.

3. InputBox for User Input Code

Sub GetUserInput()
    Dim userInput As String
    userInput = InputBox("Please enter text:", "Data Entry") ' Open InputBox
    
    If userInput <> "" Then
        Range("A3").Value = userInput    ' Write to A3 if input is not empty
    Else
        MsgBox "No data entered!", vbExclamation ' Warning message
    End If
End Sub

What Does It Do?
Prompts the user for text and writes it to A3. Displays a warning if no input is provided.

4. For Loop to Auto-Fill Rows Code

Sub FillRows()
    Dim i As Integer
    For i = 1 To 10
        Cells(i, 1).Value = i    ' Fill column 1 with numbers 1 to 10
    Next i
End Sub

What Does It Do?
Fills cells A1 to A10 with numbers 1 through 10.

5. Error Handling Code (On Error Resume Next)

Sub ErrorHandling()
    On Error Resume Next    ' Ignore errors
    Dim result As Double
    result = 10 / 0         ' Division by zero error
    
    If Err.Number <> 0 Then
        MsgBox "Error: " & Err.Description, vbCritical ' Show error message
        Err.Clear           ' Clear error
    End If
    On Error GoTo 0         ' Disable error handling
End Sub

What Does It Do?
Catches division-by-zero errors and alerts the user.

6. Worksheet_Change Event for Dynamic Control Code

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A:A")) Is Nothing Then  ' If column A changes
        Target.Offset(0, 1).Value = Now()    ' Add timestamp to column B
    End If
End Sub

What Does It Do?
Adds a timestamp to column B when any cell in column A is modified.

7. Custom Function (UDF) for Tax Calculation Code

Function CalculateTax(Amount As Double) As Double
    CalculateTax = Amount * 0.18    ' Calculate 18% tax
End Function

How to Use?
In Excel, type =CalculateTax(100) to get a result of 18.

8. Conditional Logic (If-Else) with MsgBox Code

Sub CheckValue()
    Dim value As Double
    value = Range("C5").Value
    
    If value > 100 Then
        MsgBox "Value exceeds 100! Warning!", vbExclamation ' Alert
    Else
        MsgBox "Value is within normal range.", vbInformation    ' Info message
    End If
End Sub

What Does It Do?
Checks cell C5 Alerts if the value exceeds 100 otherwise shows a confirmation.

Notes for Using the Code:

1. Open the VBA editor in Excel with Alt + F11.
2. Insert a new module and paste the code.
3. Run macros via Alt + F8.