Watch this super-cool project where we learn how to create a scrollable filter result list. This incorporates Excel features like Data Validation, Form Controls, VBA, and Dynamic Array functions.

File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_ScrollList.zip

01:44 File Download Instructions
01:56 Overview of Features Used
02:16 Examining the Data Source
02:29 Create a List for a Data Validation Drop
03:45 Naming the User’s Region Selection
03:54 Repeating the data’s Header Row
04:40 Filtering the data by the User’s selected region
05:35 Creating a Scrollbar Form Control
06:37 Setting Scrollbar Controls
07:43 Testing Form Control Behavior
08:01 Skipping Beginning Records
09:25 Hiding Last N Rows
10:05 Determine /”end of data/” range
10:52 Marking Results Range
11:31 End Scroll Range Prematurely
12:48 Defining the scroll limit problem
14:09 VBA code to reprogram Scrollbar MAX
15:42 Naming the Scrollbar
17:47 Updating MAX when rows are added/deleted
20:24 Generate Sequence Numbers
22:13 Remove Redundant Columns
24:33 Finished Project

Please take the opportunity to connect and share this video with your friends and family if you find it useful.