Adding a specified number of rows in Excel, via a User Form

B

BSGApollo

Joined
Jun 21, 2011
Messages
1
Reaction score
0
Hello,

I am trying to create a User Form to use with a new Excel log I am setting up, and I'm stumped on how to get a specified number of rows inserted.

The User Form I have includes a Combo Box with some set numbers in, currently 1 - 13. What I would like is on clicking OK, whichever number was specified in the combo box is how many new rows are inserted.

I already have the code to find the last row used, so I now just need the new rows inserted. I also ideally need them to retain the formatting of the rows above them. Any idea's?

Also, while I'm here, I then need to insert information from other fields on the User Form, for example a specified script name, into those boxes that I have just inserted. Is this possible or am I getting away from myself?

Any help would be greatly appreciated.

Thanks
Apollo
 

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

Automatically Increment numerically ordered rows 3
VBA - retrieve data on last create named range from previous inserted named range 0
Copying row & inserting 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Inserting multiple rows 2
Automatically insert new rows 2
Add rows after hiding rows 1
Adding rows once data is entered 1

Top