UserForm with filtered data

[BanginMyHeadOnMyDesk]

The attached has a very simple UserForm (a drastically simplified version of something I use at work). By using the spin button you can cycle through the records on the Data sheet.
This all works great, however, when the data is filtered it falls over when you get to a record that's not showing due to the filter.

So I'm looking for an elegant solution to get around this. Any ideas?

Thanks in advance

B

[brokenbiscuits]

Change your code for SpinButton1 to:

Please Login or Register  to view this content.

This should skip any filtered out values

or if you wanted to include filtered-out values, instead change your TextBox1 change code to:

Please Login or Register  to view this content.

[simcode]

Here it is

[BanginMyHeadOnMyDesk]

Thanks for that brokenbiscuits. It works, almost. It allows me to scroll forward through the rows but not backward.
For example if I have references 222 and 444 hidden, the form starts at 111 and I can go to 333 and 555, but if I'm on 555 I cannot get back to 333 or 111.

B

[BanginMyHeadOnMyDesk]

Here it is

Thank you simcode, but I need it not to show the filtered rows. Should have mentioned that in my original post. Apologies.

B

[simcode]

This time, the code is longer than before, but Textbox2 & Textbox3 will response to changing of Textbox1.

[jindon]

Try

Please Login or Register  to view this content.

[brokenbiscuits]

EDIT: Actually, this would still need some error-checking building in - I could do this, but far better to use simcode's alternative above as it's already working!

Of course, complete oversight by me!

You need to get rid of the SpinButton_Change and replace with:

Please Login or Register  to view this content.

[BanginMyHeadOnMyDesk]

Thanks for the help everyone. Three great solutions there. :D

B