repeat vba based on TextBox value

  • Hello Guys,

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

    Private Sub CommandButton3_Click()
    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!