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.
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.
thanksVB: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
Last edited by Wigi; May 31st, 2007 at 21:43.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)