PDA

View Full Version : Solved: Display results from a formula into a form



ProteanBeing
12-14-2007, 01:43 PM
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
12-14-2007, 02:58 PM
To get the total rows



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


To display it



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

ProteanBeing
12-17-2007, 09:07 AM
Thanks! That was so easy I kinda feel stupid....:doh: