Variables

A variable stores a value that can change while a VBA program runs.

Example

Dim Sales As Double

Sales = 50000

Common Data Types

Data Type	Purpose
Integer	Whole numbers
Long	Larger whole numbers
Double	Decimal numbers
String	Text
Boolean	True/False
Date	Dates and times
Variant	Can store different types

Example

Dim EmployeeName As String

Dim Salary As Double

Dim IsActive As Boolean

EmployeeName = “Amit”

Salary = 45000

IsActive = True

Practice

Create variables for:

• Student Name
• Marks
• Pass/Fail
• Joining Date