VBA Class Modules to Python Classes (With Examples)

VBA Class Modules Example

VBA

' Employee class module with properties and validation
Private mName As String
Private mSalary As Double
Private mDepartment As String

Private Sub Class_Initialize()
    ' Constructor - set default values
    mName = ""
    mSalary = 0
    mDepartment = "Unassigned"
End Sub

Public Property Get Name() As String
    Name = mName
End Property

Public Property Let Name(value As String)
    If Len(value) > 0 Then
        mName = value
    End If
End Property

Public Property Get Salary() As Double
    Salary = mSalary
End Property

Public Property Let Salary(value As Double)
    If value >= 0 Then
        mSalary = value
    End If
End Property

Public Function GetAnnualBonus() As Double
    GetAnnualBonus = mSalary * 0.1
End Function

Public Sub DisplayInfo()
    Debug.Print "Employee: " & mName & ", Salary: $" & mSalary
End Sub

Python Python classes Equivalent

Python

from typing import Optional

class Employee:
    """Employee class with properties and validation"""
    
    def __init__(self, name: str = "", salary: float = 0.0, department: str = "Unassigned"):
        """Constructor - set default values"""
        self._name = name
        self._salary = salary
        self._department = department
    
    @property
    def name(self) -> str:
        return self._name
    
    @name.setter
    def name(self, value: str) -> None:
        if len(value) > 0:
            self._name = value
    
    @property
    def salary(self) -> float:
        return self._salary
    
    @salary.setter
    def salary(self, value: float) -> None:
        if value >= 0:
            self._salary = value
    
    def get_annual_bonus(self) -> float:
        return self._salary * 0.1
    
    def display_info(self) -> None:
        print(f"Employee: {self._name}, Salary: ${self._salary}")

Common VBA → Python Mappings

VBA Class Modules	Python Python classes
Class_Initialize()	__init__(self)
Property Get Name() As String	@property def name(self) -> str:
Property Let Name(value As String)	@name.setter def name(self, value: str):
Private mName As String	self._name: str
Dim emp As New Employee	emp = Employee()
Set emp = Nothing	emp = None

Side-by-Side Comparison

VBA

' Creating and using class instance
Dim emp As Employee
Set emp = New Employee
emp.Name = "John Smith"
emp.Salary = 50000
Debug.Print emp.GetAnnualBonus()
Set emp = Nothing

Python

# Creating and using class instance
emp = Employee()
emp.name = "John Smith"
emp.salary = 50000
print(emp.get_annual_bonus())
emp = None  # or just let it go out of scope

Important Differences

Property Syntax: VBA uses separate Property Get/Let/Set procedures, while Python uses @property decorator with getter/setter methods.
Reference Management: VBA uses COM reference counting with Set/Nothing, Python uses garbage collection with automatic memory management.
Private Members: VBA has true private members, Python uses naming convention with underscore prefix for protected members.
Inheritance Support: VBA only supports interfaces via Implements, Python supports full class inheritance with super() calls.

Have VBA Class Modules to migrate?

See how properties and class patterns map to Pythonic equivalents.

Convert My VBA Code