OK... So I have made some progress...
Now I have a working scrollbar on the form that loops through the lines (and the form shows the data of the relevant line). Here is the code I am using:
What I still need is the code to apply autofilter to the database (based on a value that the user selects from a ComboBox) and then - I need the scrollbar to loop through the visible lines only, because my data is pulled to the form based on the scrollbar value, so if the scrollbar will loop though visible lines only - the form will only show the visible data as well.
BTW, I will be very happy even with a solution that assumes the database is already filtered (from within the sheet, and not from the ComboBox on in the form...) and tells the ScrollBar to loop only through the visible cells.
Hope all this is clear, even though I have not provided an example.
:-)
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks