Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to set up a number based on date entered | Excel Discussion (Misc queries) | |||
Loop through userform | Excel Discussion (Misc queries) | |||
how can i re-populate a userform with data already entered? | New Users to Excel | |||
How easy is it to loop in VBA based on cell contents? | Excel Worksheet Functions | |||
Changing chart color based on number entered | Charts and Charting in Excel |