insert number of rows based on textbox value

[bqheng]

Hi, I have a userform with a combobox and textbox. The combobox takes values in column A of Sheet1. What I hope to achieve is when users select a value in the combobox and type in a number in textbox1, the macro will find the corresponding row specified by combobox1 and insert rows based on the number specified in textbox1.

so for example, users select 10 in combobox1 and type in 3 in textbox1 and execute the macro, 3 rows will be inserted below the row with the number 10.

attached workbook for reference

[AlphaFrog]

Please Login or Register  to view this content.

[bqheng]

Thank you so much alphaFrog!!