userform summary

  • Thread starter Thread starter jonny
  • Start date Start date
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
 
Hi

Try

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