Loop based on number entered in userform
 

Hi

I have a simple userform with TextBox1, the user enters a value in
here and then based on this value does some work on that row, and i
want it to then move down a row and do the work again for the number
of rows in textbox1. How do I do a loop and count to do this please?

i.e

rowend= Me.TextBox1.Value
set a value for the counter

Start loop

If rowend=counter then end
Else
Do something
ActiveCell.Offset(1, 0).Activate
add 1 to counter
go back to start of loop

Cheers

Rich

Loop based on number entered in userform
 

The code would be like this

rowend= Me.TextBox1.Value
set a value for the counter

For A=1 to countervalue
Do something
ActiveCell.Offset(1, 0).Select
Next A

--
If this helps, please remember to click yes.


"Richhall" wrote:

Hi

I have a simple userform with TextBox1, the user enters a value in
here and then based on this value does some work on that row, and i
want it to then move down a row and do the work again for the number
of rows in textbox1. How do I do a loop and count to do this please?

i.e

rowend= Me.TextBox1.Value
set a value for the counter

Start loop

If rowend=counter then end
Else
Do something
ActiveCell.Offset(1, 0).Activate
add 1 to counter
go back to start of loop

Cheers

Rich