Hello, I created a userform in VBA that is used to add product options to a proposal spreadsheet. I want a command button on the userform that, when clicked: adds a new row in the proposal spreadsheet assigns an index number to the newly added row (or names the row in some way) - so users can later click a "remove" button to delete specific product options that they no longer want Thanks for your help!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to use VBA control to add rows and set a number to the added row

Thread starter kimBQT7
Start date Aug 2, 2011
Tags

vba add/delete rows

kimBQT7

New Member

Aug 2, 2011

Hello,

I created a userform in VBA that is used to add product options to a proposal spreadsheet. I want a command button on the userform that, when clicked:

adds a new row in the proposal spreadsheet
assigns an index number to the newly added row (or names the row in some way) - so users can later click a "remove" button to delete specific product options that they no longer want

Thanks for your help!