How to insert Previous, Next Button & Print Record Button in excel???

Keep in mind that i'm not the best at VBA, but I gave it a shot.

The previous and next button are a simple -1 and +1

Please Login or Register  to view this content.

Only thing that changes between the two is the - and +

They are currently assigned to sum buttons, i'll leave it up to you to make them look like you want and where you want them.

For the print x to y button the following code is used

Please Login or Register  to view this content.

The only thing you might need to change in this code is the bit marked red. This determines the range it prints, currently set to D6:V11, as this seemed logical, but change it to whatever you need it to be.

Attached is your workbook with these buttons present.

Ferdy

Koteswar - unfortunately your post does not comply with Rule 4 of our Forum RULES. 4. Do not post a new help request in an existing thread. (B)

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

By now, you ought to have read our very simple rules - please do so before posting again. Thanks.