Mopar_Mudder
New Member
- Joined
- Jan 29, 2013
- Messages
- 8
I have a user form that I use to enter data in a spread sheet, I also have a loop running that is based on values of cells in the sheet. I need to be able to enter data in the form at each step of the "for each" in the loop.
Right now I can enter data in the form once and it uses that data for each step of the loop never stopping to let me enter new data. Normally I can find a similar question somewhere and figure this coding out, but this on has got me stumped.
Sample of what I am doing:
Right now I can enter data in the form once and it uses that data for each step of the loop never stopping to let me enter new data. Normally I can find a similar question somewhere and figure this coding out, but this on has got me stumped.
Sample of what I am doing:
Code:
Private Sub commandbutton1_Click()
For Each fineline In fineline_list
For Each class In class_list
ws_item_range.Cells(iRow, 13).Value = cost 'item from user form, need to change for every step
ws_item_range.Cells(iRow, 14).Value = unit 'item from user form, need to change for every step
Next class
Next fineline
End Sub
Last edited: