loop using references to controls in userform values

HI i have a loop question relating to controls in userforms.

I am trying to loop through text boxes names bridge1 bridge 2 etc up to 9.

WHat i want is to ascertain the value of each textbox and then place that value in a totaltxtbox1 to 9.

I canhard code it but was hoping for a loop my problem is i keep getting mismatch error when i type :

Please Login or Register  to view this content.

Any thoguhts greatly appreciated.

I have simplified the issue above but a solution to the above will give me aswer to problem

Untested but try this. I have guessed your intent as pasted code doesn't quite make sense.

Please Login or Register  to view this content.

Thanks for quick reply. Sadly your code doesnt generate the correct value. It keeps generating a 0.

If i did

Please Login or Register  to view this content.

I would get the correct result but obviously no loop ability if i do that.

Any thoughts would be greatly appreciated

Works for me. You only need one line of course

Please Login or Register  to view this content.

Perhaps post a workbook?

Hi again. yep working for me now. many thanks for your help. reputation added.