Loop Through Textboxes

[HxF]

hi

This code doesn't work. Is there a way to do something like this?
The porpuse is to get the value from a textbox and put it in a cell.

For j = 1 To 10 
    If j = 1 Then 
        txt = 25 
    ElseIf j = 4 Then 
        txt = 57 
    End If 
    Range("G" & i + 8 + (2 * j)).Value = TextBox & txt & .Text 
    Range("H" & i + 8 + (2 * j) + 1).Value = TextBox & txt + 1 & .Text 
    Range("H" & i + 8 + (2 * j) + 2).Value = TextBox & txt + 2 & .Text 
    Range("H" & i + 8 + (2 * j) + 3).Value = TextBox & txt + 3 & .Text 
    txt = txt + 4 
Next j 

thanks

[Wigi]

A small example sheet will be handy to get what you mean. Also, write it down in plain English, sentences understandable to all of us.

[JimFuller1]

HxF,

If you are saying that you have information stored in text boxes that you have to retrieve on a regular basis, you need to think about not storing your data in text boxes so you don't have this problem.

If you're saying you have a bunch of text boxes and you want to retrive the information once before you stop collecting data in text boxes, you could look at the link below. It may help you to understand how to loop through the text boxes.

http://www.ozgrid.com/forum/showthread.php?t=31825

Jim

[Mavyak]

Edit: Disregard. Bad logic written on the fly...

[HxF]

Thanks for the help.

The link is very handy.

thanks once again and I'm sorry for the bad english.