Calculating the total a number of cells that varies

[philfloyduk]

Hi all.

I have a sheet and userform that deals with our parts orders. Each time a part is put on the order the rows (from row 5) are shifted dowards to make way for the next part. The user manages this all with a userform which they view and process the order from.

What I would like to happen is that the _initialize on the form calculates the total price on the sheet at that time and puts it in the tbTotal textbox. If it makes it simpler there can be a limit of row 30 as it's highly unlikely we would have that many entries without processing the order.

Any help offered will be much appreciated!

Many thanks

Phil

 

[GlennUK]

I think a label would be more appropriate ... the user should not be allowed to overwrite or enter into the textbox, surely.

To find the sum of a range in VBA it's simple, like this:
mysum = Application.Sum(Range("F2:F30"))

Does that help?

 

[philfloyduk]

Hi Glenn.

Thank you for your help, that does the job. I have the textbox locked, I simply prefer the appearance of them over labels.

Phil