Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-03-2022, 09:56 AM
14spar15 14spar15 is offline Scroll list to this point Windows 7 64bit Scroll list to this point Office 2010 64bit
Competent Performer
Scroll list to this point
 
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default

Great, this works well. I tried for days to do something ActiveX Controls with no luck. The list seldom changes so changing the parameters in the code-module is absolutely no problem. My actual worksheet is so large that I have actually separated it into this red and blue group. I put my most looked up names in the red list and the others in the blue because I still have 40 to 50 names in the list starting with say an M.
A couple of other things here. Freezing the first five columns in the traditional method does not seem to work. I get the dark grid line between columns E and F but the columns are not frozen. Could this be fixed? Also one other thing that would be nice if possible. It would be helpful if in addition to selecting one of the red search letters, a letter could be entered into cell B1 and this would be the same as selecting that red letter. This letter would be entered from an outside source as the worksheet gets focus. Hopefully, one of the click letters could then still be used if I am not getting the results I was expecting. Perhaps on this added click, B1 would have to be cleared. Probably just need to do this for the red section. Thanks again for the help here.
Reply With Quote
 



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
Scroll list to this point 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft