How To Change A Cell Value With VBA - Techwalla

Get the latest news and alerts! Later Notify

1. Tech Support
2. How To

How to Change a Cell Value With VBA By Jaime Avelar Fact Checked Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here. Update Excel values in VBA.

You may need to change the value in a cell when working with Excel and Visual Basic for Applications, or VBA. With VBA you can modify cells automatically without the need to manually change the values. You can accomplish this task by using the Range object in VBA to select the cell you want to change. Once the cell is selected, then you can use the ActiveCell property to change its value or other properties.

Advertisement

Step 1

Launch "Microsoft Office Excel" and type "data in A1" in cell A1. Click the "Developer" tab, and click "Visual Basic" to open the VBA Editor Window.

Video of the Day

Step 2

Click the "Insert" menu, and click "Module" to insert a new module.

Advertisement

We Recommend

Tech Support How to Make Text Flash in Excel By Shawn McClain Tech Support How to Delete Data in Excel & Not Formulas By Athena Hessong Tech Support How to Calculate Sample Size in Excel By Carter McBride

Step 3

Create a new String variable by typing the following:

We Recommend

Tech Support How to Make Text Flash in Excel By Shawn McClain Tech Support How to Delete Data in Excel & Not Formulas By Athena Hessong Tech Support How to Calculate Sample Size in Excel By Carter McBride

Dim data As String

Step 4

Copy and paste the following code to change the value in cell A1:

Advertisement

Advertisement

Range("A1").Select data = Range("A1").Value If data = "data in A1" Then ActiveCell.Value = "A1 data changed" Else MsgBox "Data is OK." End If

Step 5

Press "F5" to run the procedure and change the value in A1. Run the procedure a second time, and you will get a message box stating that the data are OK.

Video of the Day

Advertisement

Advertisement

references

• MSDN: Range Object
• MSDN: Working With the Active Cell

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

People are Reading

1

How to Extend the Trend Line in Excel

2

How to Do a Percentile in Excel

3

How to Normalize in Excel

You May Also Like

1

How to Figure Frequency Percentages in Microsoft Excel

2

How to Calculate Normalized Data in SPSS

3

How Do I Add a Background Color or Pattern to Excel Cells?