userform summary

J

jonny

I am trying to make an annual financial summary on a
userform which flashes up when the user double clicks.

I can do everything i need except sum a list of prices in
one column so i can display it in a label on the userform.

I know that this should be very simple but i just can't
get it to sum column a sheet2, i assumed it would be
something like....

Tots = Sum("a1:a33")
Label3.Caption = Tots

TIA
 
H

Harald Staff

Hi

Try

Dim Tots As Double
Dim myRange As Range
Set myRange = Worksheets(1).Range("A1:A33")
Tots = Application.Sum(myRange)
Label3.Caption = Tots
 
Top