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 :

dim total as integer
for i = 1 to 9 

total = "bridge" & i ".value"
"totaltxtbox" & i = total
Next i

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.

For i = 1 To 9
    total = Me.Controls("bridge" & i).Value
    Me.Controls("totaltxtbox" & i).Value = total
Next i

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

If i did

 total = me.bridge1.Value
    Me.totalbox1.value = total

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

Me.Controls("totaltxtbox" & i).Value = Me.Controls("bridge" & i).Value

Perhaps post a workbook?

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