VBA Plus / Macros Chapter – 1 (Swap Values – 1)

This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs as we will see later.

Situation:

Two values on your worksheet.

Place a command button on your worksheet and add the following code lines:

1. First, we declare a variable called temp of type Double.Dim temp As Double

2. We initialize the variable temp with the value of cell A1.temp = Range(“A1”).Value

3. Now we can safely write the value of cell B1 to cell A1 (we have stored the value of cell A1 to temp so we will not lose it).Range(“A1”).Value = Range(“B1”).Value

4. Finally, we write the value of cell A1 (written to temp) to cell B1.Range(“B1”).Value = temp

5. Click the command button two times.

Result:

Continue learning

All Excel VBA guides →

Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)This practical VBA exercise explains one small technique at a time. Work in a…Basics of VBA / Macros Chapter – 23 (Delete Blank Cells Part-1)A practical VBA lesson to remove genuinely blank records safely without skipping rows or…Basics of VBA / Macros Chapter – 43 (String Manipulation Part-5)This practical VBA exercise explains one small technique at a time. Work in a…VBA Runtime Error 1004: Complete Troubleshooting & Code FixesRun-time error '1004': Application-defined or object-defined error is the most common and frustrating error…