VBA Sum of a Range

[DaveLoos]

I am sure this is a simple answer, but I have looked all over several forums and I am struggling to figure out how to get SUM of a column of values input into a textbox on my userform.

I am getting the user to input a range of dates then I have variables that hold the start row (iRow) and end row (iRowX).

I need something like:

txtReg.value = SUM(Range("D" & iRow & ":D" & iRowX))

I have learned that this does not work in VBA but what would be the correct way to make this work?

Thank you in advance for any help you can offer!

 

[doubledaffy]

Try:

txtRng.value=WorksheetFunction.Sum(Range("D"&iRow&":D"&iRowx))

 

[DaveLoos]

Thanks a lot! I was still getting an error but I just had to add spaces around the "&" signs for it to work.