Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code that enter data into my worksheet from textbox and labels.
ws.Cells(iRow, 1) = iRow - 1 ws.Cells(iRow, 2) = Me.txtRFID.Value ws.Cells(iRow, 3) = Me.DTPicker1.Value ws.Cells(iRow, 5) = Me.TextBox1.Value ws.Cells(iRow, 4) = Me.Label1 Problem is i could have as many as 11 textboxes and label with values never constant. how do you write this to enter so that it enters this code the for the tb1 and lbl1 then run again if there is tb2 and lb2 and so on. Would it be a loop? -- Thank you, Jennifer |