Excel VBA

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

I am trying to create a command button so that when a user clicks on the
command button a message box pops up with the the answer to 2 cells added
together
 
Added as in Summed like =A1+B1

Or added like =A1 & B1

Go with the first one.

Create a Command Button with this code

Private Sub CommandButton1_Click()
Dim rng As Range
Set rng = ActiveSheet.Range("A1:B1")
MsgBox "sum of A1 and B1 is " & Application.WorksheetFunction.Sum(rng)
End Sub

No error trapping.


Gord Dibben MS Excel MVP
 
The code looks like this:

sub Sum_of_two_cells()
msgbox range("a1").value + range("b1").value
end sub

You can use the Control Toolbox on the Visual Basic toolbar to assign
the macro to a button; I prefer to click (on the Excel menu) >View
Toolbars >Forms and use the command button from that toolbar.
Click to expand...

Good luck with it!
Dave O
Eschew obfuscation
 
Back
Top