Friday, August 29, 2008

Using Excel Functions in VBA - Sum

Sub function_sum()
x = 2
y = 3
some = WorksheetFunction.Sum(x, y)
End Sub

Try to modify code to
1) Display the numbers being added and the sum.
2) Get numbers as user input and sum them up.

Find out how is concatenation done in VBA. It has already been used in previous examples.



No comments:

Post a Comment