Microsoft Excel - Limited Scroll List (with VBA Trick-shot)

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_D...

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

• #
• #choosecols
• #countifs
• #drop
• #data_validation
• #dynamic_array
• #filter
• #form_controls
• #sequence
• #sort
• #take
• #unique
• #vba