Why do I always get stumped on the easy things..

[Chandler_90]

.... When I can generally think my way through more complex issues.

I need to write some vba which basically cycles through rows in excel on the click of a button.

Basically a next button that will display the data for the next row in a front end much like the "Data Form" utility in Excel.

It might just be as I'm tired and at work that I can't remember and google ain't my friend at the minute!

Any ideas?
I acomplished this in Access with VBA but don't have the applications or files here to give it a shot.

I'm creating a enhanced version of the excel "Dataform" without the new/delete keys and chaning the criteria button to be captionned search lol.

Thanks, Ray.

 

[RockLobster]

Example of going through rows: -

For i = 2 To 20
Range("J" & i).Value = Range("G" & i).Value
Next i

http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html - Example on how to create forms.

Create a basic form with a Next button and a label or textbox and messing with the code above you are half way there.