Using offset to select cells ignoring filtered results

[peterchclarke]

I have a userform that will enable users to edit a database, I have an up and down arrow that scrolls through the database. I want to filter the database and use the userform to scroll through only the filtered results.

Please Login or Register  to view this content.

this code keeps it in the table, how do I use:

Please Login or Register  to view this content.

to only select the items that are visible?

[nigelog]

Can you use the filtered value(s) to navigate

Please Login or Register  to view this content.

[rorya]

You could simply loop while the next row is hidden:

Please Login or Register  to view this content.

[peterchclarke]

Thank you very much. When I used this, because the main data set (not the spreadsheet attached) has blanks, i think this caused issues, which I resolved by selecting a column that had no blanks on initializing the form.

I came up with a subsequent error where if the data was filtered, the code from rorya allowed the button to go one below the extent of the table.

I solved using the following, but it looks very ugly! Effectively I reversed the code to make it go back up, which I also used for the "UP" button.

Please Login or Register  to view this content.

Any thoughts on improving this?