how loop specific textboxes to sum the values on userform

[ABDELFATTA]

Hi
can anybody help me to write simple code too loop through specific textboxes to sum the values?
I have textboxes from 34:45 shows the values inside them .what I want to sum the values for each textbox and the total shows in textbox46 .so I sreach for way like loop. this is waht I try to do that

Please Login or Register  to view this content.

but gives mismatch error in this TControl, any idea to fix it,please?

[JohnTopley]

Please post a sample file: instructions in yellow banner at top of page

[torachan]

Try

Please Login or Register  to view this content.

[JohnTopley]

Try

Please Login or Register  to view this content.

[ABDELFATTA]

@torachan
thanks . it gives object variable or with block variable is not set in this line

Please Login or Register  to view this content.

[ABDELFATTA]

@JohnTopley thanks give me mismatch in this TControl as in OP

[torachan]

Maybe ???

Please Login or Register  to view this content.

[ABDELFATTA]

@torachan thanks but I'm afraid shows problem about number format if i Have number format in textboxes like this "#,##0.0"
doesn't gives me right values. is there any way to deal with number format when summing .

[torachan]

upload your workbook to prevent a guessing game developing.

[ABDELFATTA]

here is the file

[torachan]

Hammer to crack a walnut.

Please Login or Register  to view this content.

[ABDELFATTA]

much appreciated for your solution

[torachan]

thanks for the feedback and rep point.