![]() So, you create a new module and paste there code for WinAPI calls: Option Explicit Though I made (little bit more complicated) version that is compatible with both 32-bit and 64-bit, but it just don't scrolls on 64-bit, but at least compiles (please let me know if somebody needs that 64-bit compatible code). The code won't compile and run at all under 64-bit Excel. You can get it to work only on 32-bit Excel. I don't have access to another configuration to test this. The same issue has appeared on other computers as well also running the same setup. I am using Excel 2010 (32bit) on a Windows 7 64bit laptop. Me.KeepScrollBarsVisible = fmScrollBarsVertical Here is the code where I enable scrolling: If Me.height > 500 Then ![]() Other articles I've found are dated back to Excel 2003 which did not support mouse wheel scrolling out of the box.ĭoes anyone have any idea what's going on here? Every article I've found on Google points to scrolling controls within a UserForm (ListBox, ComboBox, etc.) and not the UserForm itself. I haven't seen any properties for enabling mouse wheel scrolling. The scrollbars appear and work as expected when clicking on the scrollbars, but the mouse scrollwheel has no effect on the scrollbars on the form. If it is, then the form gets set to a maximum height of 500px and scrolling is enabled. My code adds all the controls and then determines if the form is excessively long. ![]() Controls are added to the form programmatically based on data from a particular sheet. I have a UserForm I've created in Excel 2010 using VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |