VBA Userform Next and Previous Buttons that work on current activesheet/open sheet

I am new to coding in VBA but have been able to figure how to add next and previous buttons. The problem is they always go through the data in "Sheet1" and will not work on the other sheets after I activate them. I have a combobox that will activate a specific sheet but after I active a different sheet the next and previous buttons are still pulling data from the first sheet. What I want them to do is when I hit the next button it will cycle through the data on the activesheet. Any help is appreciated.

The Code for the Next Button:

Please Login or Register  to view this content.

The code for the previous button is:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

In addition uplod the workbook so that we may see therequest in context

You'll have to talk me through this and how you use it in practice. It's rather a busy form
When I load the form it is unpopulated, should the various boxes be filled in


When you say you activate sheets how are you doing that? Via the userfrm or manually by selecting a different sheet.
How do you load the Userform, via the Excel run macro menu or via a button?

And when you talk about cycling through the data I presume you expect records from the database to appear in the form, but as I say above there is no data in the frm. How do you select the first record to populate the sheet. The various boxes don't appear to be drop downs which rather suggests you're manuall entering stuff and the prime purpose is to send new data back to the sheet database, hence as I say what does 'cycle through data' really mean.



In essence though you should have a Sheet Variable that identifies a sheet and then fully quaify any reference to a range by prefacing it with the sheet variable