Solved: Display results from a formula into a form

[ProteanBeing]

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.

[Bob Phillips]

To get the total rows



TotalRows = Application.Counta(Worksheets(1).Columns(1))


To display it



Label1.Caption = "Row " & ThisRow & " of " & NumRows

[ProteanBeing]

Thanks! That was so easy I kinda feel stupid....:doh: