From forms into a new row neatly?

  • Thread starter Thread starter count
  • Start date Start date
C

count

Hi,
Can you recall this nifty looping way of populating new row when form is
OK-yed?
I believe this technique gives code immunity to adding new fields|columns.
Txs Paul
 
rw = 10
i = 1
for each ctrl in userform1.controls
Cells(rw,i) = ctrl.Value
i = i + 1
Next
 
Back
Top