the form displays a row from a sheet (like an access record form). On the bottom I have buttons that go to the next and previous rows. I would like to have a "row of rows" display (ex. 1 of 200). Please help.
the form displays a row from a sheet (like an access record form). On the bottom I have buttons that go to the next and previous rows. I would like to have a "row of rows" display (ex. 1 of 200). Please help.
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
To get the total rows
[vba]
TotalRows = Application.Counta(Worksheets(1).Columns(1))
[/vba]
To display it
[vba]
Label1.Caption = "Row " & ThisRow & " of " & NumRows
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks! That was so easy I kinda feel stupid....
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being