Looping through controls in tab index order

[jcg31]

I am trying to loop through a series of textboxes and place the value in a corresponding cell ie. tb1=cells(x,1) tb2=cells(x,2) etc.

I thought by making certain that the tab index was in the proper order that the loop would follow the same order but that doesn't seem to be the case. Can someone provide direction for how to control the order of the loop?
Thanks for any help,
Jim