| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
From forms into a new row neatly?
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 |
Threaded Mode
