Previous/Next button on UserForm calling to data on a hidden sheet

[nickek02]

Greetings -

I am trying to build a form to update data on a hidden sheet ("Employees") but I am running into issues when coding the previous and next record buttons on the form. I have used coding found in other examples on this forum and others but keep running into issues where the form goes through records on the visible worksheet and not the hidden sheet or get a runtime error on the LastRow/CurrentRow lines. I seem to be going in circles and need some help as I am not an expert by any means.

Below is the code I currently have on the Form.

Everything is working except the Previous and Next buttons.

Please Login or Register  to view this content.

Thanks for your help!

[gmr4evr1]

For the Previous code, you have Sheets("Employees").Select
If the sheet is hidden, the code will give an error because it cannot select a hidden sheet. You must 1st make the sheet visible, then select it.
As for the Next code, not sure what is going on there without seeing a sample of the code with userform etc.

[nickek02]

I make the sheet visible in the UserForm_Initialize script.

[gmr4evr1]

Sorry, somehow I missed that.