Thanks Bernie Deitrick, But it would be appreciate , if you could send the
VBA code for this !

Regards
jOPHY

Bernie Deitrick wrote:
Assumption: you've filtered your database to extract the 25 records that you
want to display. (You can use the autofilter method and visiblecells
property to get those records and read them into an array.)

When the "Next" button is clicked, simply read from that extract using
indices that are 5 higher than previously, or 5 lower for the "Previous"
button. Store the current index in a variable, and you're all set.

HTH,
Bernie
MS Excel MVP

In a worksheet around 500 records are there -Employee number,employee
name,
[quoted text clipped - 20 lines]

Please help me to find the solution for this .


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200507/1