Thread: Looping
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Looping

Try:

If ActiveCell.Row < 65536 Then Cells(ActiveCell.Row + 1,
ActiveCell.Column).Select


"Steve" wrote:

I want to start in cell A1 and each time I click a button on a userForm I
want the cursor to move to the next cell, in this case, a2. Then, if the
cursor is in a2, when the button is clicked again, I would like the cursor to
move to a3.

Any ideas?

Thanks,