|
|
#2
08-02-2022, 12:51 PM
|
||||
|
||||
Click on one of the letters on the left in the attached and if an entry exists beginning with that letter the whole sheet will scroll so that the top row contains the first entry with that first letter.
There are comments 'hardcoded in the code which means you need to change those lines to suit your actual circumstances. The code is to be found in Sheet1's code-module. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need to scroll Excel list and select random name | GreySquirrel | PowerPoint | 1 | 07-12-2019 12:06 PM |
| Is there a way to display quickparts as a panel rather than a scroll list? | Very Terry | Word | 2 | 04-26-2017 07:08 AM |
 Cannot scroll past specific point in doc
|
sunriver | Word | 3 | 06-24-2015 07:00 PM |
| Page does not actively scroll with click, hold and drag on scroll-bar | jbax | Word | 1 | 05-09-2013 07:16 PM |
| Power Point copy-paste number list to RTF editor | himanshu | PowerPoint | 0 | 02-22-2010 12:56 AM |
Windows 10 
Office 2019
Threaded Mode