In the thread that this one was based on (VBA To Scroll Through ListBox Using Mouse Scroll Wheel), MrBlackd raised an excellent point about font size and modern monitors with higher resolutions than I use. It seems that on those monitors, my UserForm comes out somewhat smallish. MrBlackd suggest using the font and font size he uses and I have done so; he also made an excellent suggestion as to making sure the form appears on the same screen (important for multi-monitor setups) and I have adopted the code he posted to do this as well. So thanks go out to MrBlackd for his suggestions! I have modified the code attached to Message #1 as indicated above. If have you already have downloaded my original files earlier, you should replace them with the new files now contained in the attachment to Message #1.




Reply With Quote
Bookmarks