VBA Text Box Value = Sum of Cell Range

[iaindowner]

My question is simple I think yet I still cannot come up with the answer. I have an active x text box and I want the text box value to equal the sum of a range of cells.

This doesn't seem to work.

Value = Application.WorksheetFunction.Sum(Range("F2:F100"))

 

[jim may]

TextBox1.Value = WorksheetFunction.Sum(Range(Range("F2"), Range("F100")))