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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
update a new row everytime I click a button 1
Excel Help to copy information from one row at a time to another sheet 1
Getting data from Word forms into Excel 2
VBA - retrieve data on last create named range from previous inserted named range 0
Tax Form with Merge and Center 7
inserting data in next row on clicking a button 2
Breaking One Row into Multiple Rows using VBA Macro? 2

Back
Top