How to add new blank row and insert data in each cell using VBA user form.
i have a spreadsheet with rows already populated. click of a button asks for where to insert blank row.as user specifies the row number . blank row is created and new user form pops up and user enters data and clicks submit button and these data should populate in the respective cells in the blank row
Attached file
If command button cliked . i type 12 and then the next form text box 1 value to populate in A12 and text box 2 B12
Bookmarks