How To Add Two Cell Values In Excel Vba

by

To add two cell values in Excel VBA, you can use the following steps:

  1. Define the variables to hold the cell values and the result. For example:

            
          Dim cell1 As Range
          Dim cell2 As Range
          Dim result As Double
  2. Set the cell objects to the desired cells. For example, to add the values in cell A1 and B1, use:

            
          Set cell1 = Range("A1")
          Set cell2 = Range("B1")
  3. Retrieve the values from the cells and add them using the appropriate operator. For example:

            
          result = cell1.Value + cell2.Value
  4. Display or use the result as needed. For example:

            
          MsgBox "The result is: " & result

Here’s a complete example that adds the values from cell A1 and B1 and displays the result in a message box: 

    
      Sub AddTwoCellValues()
          Dim cell1 As Range
          Dim cell2 As Range
          Dim result As Double
          
          Set cell1 = Range("A1")
          Set cell2 = Range("B1")
          
          result = cell1.Value + cell2.Value
          
          MsgBox "The result is: " & result
      End Sub

Leave a comment