Excel VBA Assignment Operator (=) – Complete Guide with Examples

Excel VBA Assignment Operator (=)

Complete Guide to Assigning Values to Variables, Cells and Objects in VBA

← Previous Assignment Operator Next →

Introduction to the VBA Assignment Operator

The Assignment Operator (=) is one of the most important operators in Excel VBA.

It is used to assign a value to a variable, cell, property, object or expression result.

In simple words, the assignment operator tells VBA:

"Take the value on the right side and store it in the item on the left side."

For example:

Dim age As Integer age = 42

Here, VBA calculates or reads the value 42 and stores it inside the variable age.

1. Basic Syntax of Assignment Operator

The basic syntax is:

variable = value

Example:

Dim name As String name = "Chirag"

The value "Chirag" is assigned to the variable name.

Important:

• Left side = destination
• Right side = value or expression
• = performs the assignment

2. Left Side and Right Side of =

Consider this statement:

total = price * quantity

VBA processes it conceptually like this:

Step 1: VBA calculates:
price * quantity

Step 2: The result is stored in:
total

Therefore:

Left Side = Destination Right Side = Value / Expression

3. Assigning Text to a Variable

String values are assigned using double quotation marks.

Dim customerName As String customerName = "Rahul"

Now the variable contains:

customerName → "Rahul"

Another Example

Dim city As String city = "Delhi" MsgBox city

The message box displays Delhi.

4. Assigning Numbers

Numeric values can be directly assigned to numeric variables.

Dim quantity As Integer Dim price As Double quantity = 10 price = 125.50

VBA stores the values in the corresponding variables.

Result:

quantity = 10
price = 125.50

5. Assignment Using an Expression

The right side does not have to be a simple value. It can contain an entire expression.

Dim a As Integer Dim b As Integer Dim result As Integer a = 10 b = 20 result = a + b

VBA first calculates:

a + b = 10 + 20 = 30

Then VBA assigns 30 to result.

6. Assignment with Mathematical Calculations

You can use arithmetic operators on the right side of the assignment.

Dim total As Double total = 100 + 50

Result:

total = 150

Using Variables

Dim price As Double Dim quantity As Integer Dim total As Double price = 250 quantity = 4 total = price * quantity MsgBox total

Output:

1000

7. Assigning a Value to an Excel Cell

The assignment operator is heavily used when working with Excel cells.

Range("A1").Value = "Hello"

This puts Hello into cell A1.

Assign Number

Range("A1").Value = 100

Assign Calculation

Range("A1").Value = 50 + 25

Cell A1 will contain:

75

8. Reading a Cell into a Variable

Assignment also works in the opposite direction.

Dim customerName As String customerName = Range("A1").Value

If A1 contains:

Chirag

Then:

customerName = "Chirag"

This is extremely useful when building Excel VBA automation.

9. Copying One Cell to Another

You can use the assignment operator to copy a cell value.

Range("B1").Value = Range("A1").Value

If A1 contains 100, B1 will also contain 100.

Another Example

Range("D5").Value = Range("B5").Value

10. Assigning a Variable to a Cell

Dim salesAmount As Double salesAmount = 25000 Range("B2").Value = salesAmount

The value stored in the variable is written into cell B2.

11. Assignment with Cell Calculations

You can directly calculate values from Excel cells.

Range("C2").Value = Range("A2").Value + Range("B2").Value

If:

A2 = 100 B2 = 200

Then:

C2 = 300

12. Assigning a New Value to an Existing Variable

A variable can be assigned a new value multiple times.

Dim score As Integer score = 50 score = 75 score = 90

The final value is:

score = 90

The previous values are replaced.

13. Increasing a Variable

You can use the assignment operator with the existing value of a variable.

Dim counter As Integer counter = 10 counter = counter + 1

The result is:

counter = 11

Increasing by 10

counter = counter + 10

This technique is commonly used inside loops.

14. Decreasing a Variable

Dim balance As Double balance = 1000 balance = balance - 250

Final value:

balance = 750

15. Assignment with the Concatenation Operator

The assignment operator can be combined with the concatenation operator &.

Dim firstName As String Dim lastName As String Dim fullName As String firstName = "Chirag" lastName = "Coder" fullName = firstName & " " & lastName

Result:

Chirag Coder

Notice that = assigns the final result to fullName, while & joins the text.

16. Assigning Dates

You can assign the current date using VBA's Date function.

Dim todayDate As Date todayDate = Date

Current date is stored in the variable.

Current Date and Time

Dim currentDateTime As Date currentDateTime = Now

17. Assigning Boolean Values

Boolean variables can contain either True or False.

Dim isActive As Boolean isActive = True

You can later change it:

isActive = False

18. Assignment Operator with Objects

VBA also uses Set when assigning an object reference.

Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Sheet1")

Important:
For normal values, use:

variable = value

For object references, use:

Set objectVariable = object

19. Assignment to Excel Properties

VBA uses the assignment operator to change many Excel properties.

Change Cell Value

Range("A1").Value = "Sales Report"

Change Font Size

Range("A1").Font.Size = 16

Change Font Bold

Range("A1").Font.Bold = True

Change Column Width

Columns("A").ColumnWidth = 20

20. Assigning the Result of a Function

A function can return a value, and that value can be assigned to a variable.

Dim textLength As Long textLength = Len("Excel VBA")

The function returns the length of the text and assigns it to textLength.

Using UCase

Dim result As String result = UCase("excel vba") MsgBox result

Output:

EXCEL VBA

21. Assignment Inside an If Statement

Assignment is frequently used inside conditional statements.

Dim sales As Double Dim status As String sales = 75000 If sales >= 50000 Then status = "Target Achieved" Else status = "Target Not Achieved" End If MsgBox status

Here the assignment operator stores different values depending on the condition.

22. Assignment Inside a Loop

Assignment operators are extremely important when working with loops.

Dim i As Integer For i = 1 To 5 Cells(i, 1).Value = i Next i

This writes numbers 1 to 5 into cells A1:A5.

23. Real-World Example – Calculate Invoice Total

Let's create a simple invoice calculation using the assignment operator.

Sub CalculateInvoice() Dim quantity As Integer Dim price As Double Dim subtotal As Double Dim tax As Double Dim grandTotal As Double quantity = Range("B2").Value price = Range("C2").Value subtotal = quantity * price tax = subtotal * 0.18 grandTotal = subtotal + tax Range("D2").Value = subtotal Range("E2").Value = tax Range("F2").Value = grandTotal End Sub

This example demonstrates how the assignment operator is used throughout a real Excel automation process.

24. Common Mistakes with the Assignment Operator

Mistake 1 – Forgetting Quotes Around Text

name = Chirag

This is incorrect if Chirag is intended to be text.

Correct:

name = "Chirag"

Mistake 2 – Reversing the Assignment

100 = total

This is invalid because the left side must be something that can receive the value.

Correct:

total = 100

Mistake 3 – Forgetting Set for Objects

Dim ws As Worksheet ws = Worksheets("Sheet1")

Correct:

Set ws = Worksheets("Sheet1")

25. Is = Used for Comparison or Assignment?

The = symbol can be used for both assignment and comparison depending on where it appears.

Assignment

x = 10

This assigns 10 to x.

Comparison

If x = 10 Then MsgBox "x is 10" End If

Here = checks whether x is equal to 10.

Remember:
Outside a condition, = commonly performs assignment.
Inside a condition such as If, = is used for comparison.

26. Assignment vs Comparison Operator

Feature	Assignment	Comparison
Operator	=	=
Purpose	Assign a value	Compare two values
Example	x = 10	If x = 10 Then
Result	Stores value	True or False

27. VBA Assignment Operator – Quick Reference

Example	Meaning
x = 10	Assign 10 to x
name = "Chirag"	Assign text
total = price * quantity	Assign calculation result
Range("A1").Value = 100	Write value to cell
x = Range("A1").Value	Read cell into variable
x = x + 1	Increase x
x = x - 1	Decrease x
Set ws = Worksheets("Sheet1")	Assign an object reference

28. Practice Questions

Try to solve these questions yourself.

1. Create a variable called age and assign 42 to it.
2. Create a String variable called city and assign "Delhi".
3. Create two variables and calculate their total.
4. Read cell A1 into a VBA variable.
5. Write a variable's value into cell B1.
6. Increase a variable by 5.
7. Decrease a variable by 10.
8. Create a full name using the & operator.
9. Assign today's date to a Date variable.
10. Create a Worksheet object variable using Set.

29. Mini Project – Calculate Employee Salary

Let's use the assignment operator in a small practical project.

Sub CalculateSalary() Dim basicSalary As Double Dim bonus As Double Dim totalSalary As Double basicSalary = Range("B2").Value bonus = Range("C2").Value totalSalary = basicSalary + bonus Range("D2").Value = totalSalary MsgBox "Total Salary = " & totalSalary End Sub

This simple example demonstrates:

• Reading Excel cells
• Assigning values to variables
• Performing calculations
• Assigning the result to another variable
• Writing the result back to Excel
• Using concatenation to display a message

30. What Should You Learn Next?

Now that you understand the Assignment Operator, the next important concept is how VBA decides which operation should be performed first when multiple operators are used in one expression.

Recommended next topic:

VBA Operator Precedence – Order of Operations

You will learn how VBA evaluates expressions such as:

result = 10 + 5 * 2

Understanding operator precedence is essential before moving to more complex VBA expressions.

31. Related VBA Operator Lessons

• Excel VBA Arithmetic Operators
• Excel VBA Comparison Operators
• Excel VBA Concatenation Operator (&)
• VBA Operator Precedence

32. Final Tip

The assignment operator = is used throughout almost every Excel VBA program.

Whenever you see a statement such as:

total = price * quantity

remember the basic rule:

VBA evaluates the right side and stores the result on the left side.

Mastering this simple concept will make variables, calculations, Excel automation, loops, conditions and VBA projects much easier to understand.

← Previous Lesson Assignment Operator Next Lesson →