How to swap Values in Excel 2022

In this tutorial we will learn how to swap Values in Excel 2022.

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.

Swap Values in Excel VBA

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:

Swap Values Result
Swap Values Result
5/5 - (1 vote)
SAKHRI Mohamed
SAKHRI Mohamed

The blog of a computer enthusiast who shares news, tutorials, tips, online tools and software for Windows, macOS, Linux, Web designer and Video games.

Articles: 3764

Leave a Reply

Your email address will not be published.