Summing TextBox Values

[gsandy]

I was using the code below to sum the values of TextBoxes (7 in total).
I am now programmatically generating the TextBoxes as required, the naming convention remaining txtPrice, txtPrice1, txtPrice2 etc.
I do have a count of TextBoxes generated in the userform = txtLines.Value.
Is there some kind of loop that would sum the variable number of TextBox values?
Thanks Sandy

Please Login or Register  to view this content.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[Leith Ross]

Hello gsandy,

Here is another way...

Please Login or Register  to view this content.

[gsandy]

Apologies guys for the delay in getting back to you. I got side tracked into another area of the same project. Thanks for the code, I will try both.
Cheers Sandy

[Rick Rothstein]

Please Login or Register  to view this content.

If the user's decimal point is a dot, the CDbl function call can be changed to a Val function call thus allowing you to remove the two On Error statements which, in turn, would allow your code to be simplified like so...

Please Login or Register  to view this content.

[gsandy]

Thanks Rick, both yours and Leith's code worked a charm. Cheers Sandy