repeat vba based on TextBox value

  • Hello Guys,


    I want to repeat this vba code based on textbox21 value (based on numbers) plz


    Code
    Private Sub CommandButton3_Click()
    Range("A65536").End(xlUp).Select
    ActiveCell.Offset(1).EntireRow.Insert
    ActiveCell.RowHeight = 25
    End Sub


    thanks in advance

  • Re: repeat vba based on TextBox value


    At a guess, you want to insert rows corresponding to the number entered in a textbox?


    Your original code modifed to loop. Note the comment



    There are more efficient ways to do this, but simplicity rules.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!