userform summary
 

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

userform summary
 

Hi

Try

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

--
HTH. Best wishes Harald
Followup to newsgroup only please

"jonny" skrev i melding
...
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