VBA sum in form

[choni]

Hi

i have textboxs named ask1 ask2 ask3 that display numbers useing this code lines

Ask1 = Range(Cells(ActiveCell.Row, 2).Value).Offset(22, 2).Value
Ask2 = Range(Cells(ActiveCell.Row, 2).Value).Offset(23, 2).Value
Ask3 = Range(Cells(ActiveCell.Row, 2).Value).Offset(24, 2).Value

I need VBA that sum and display them in textbox named SumAsk .


tnx

choni

 

[Andrew Poulsom]

Try:

SumAsk = WorksheetFunction.Sum(Range(Cells(ActiveCell.Row, 2).Value).Offset(22, 2).Resize(3))

 

[choni]

As usual work great
Tnx Andrew