rw = 10
i = 1
for each ctrl in userform1.controls
Cells(rw,i) = ctrl.Value
i = i + 1
Next

--
Regards,
Tom Ogilvy


count wrote in message
...
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