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