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
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