Calculation within VB

[jcvoth]

Greetings all!

I would like to find a way to solve simple equations through VB and print the result in something like a msgbox.

Here is an example:

******** ******************** ************************************************************************>

Microsoft Excel - Book4 ___Running: 11.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1 =
	A	B	C	D
1	Name	Sales	*	*
2	Bob	4	*	*
3	Joe	3	*	*
4	Jim	2	*	*
5	Jane	5	*	*
6	*	*	*	*
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

What I would like is to click a command button, which will trigger a new sub that will sum the range B1:B5 and print the result [14] in a msgbox.

I know how to push an equation into a particular cell, but I would like to run the whole calculation through VB.

Thank you all for your help!
-Jarrod