![]() ![]() 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. All of these controls have the same font set.I have a UserForm I've created in Excel 2010 using VBA. I've gone over the properties in all frames, labels, and textboxes in design mode and nothing stands out. This is what I've observed:ġ) The font size is dependent on the relative position within the frame the textbox needs to be entirely in the top 50% of the frame height, and adjusting the textbox position OR frame height affects the font.Ģ) This issue applies to more than one frame on this userform.ģ) This issue applies to labels as well as textboxes.Ĥ) This issue is inconsistent and does NOT apply to all textboxes and labels it's just the textboxes affected in the first frame, just the labels in a second frame, and there is no font issue in a third frame. I've since been playing around with the textbox position and frame size. Then, by accident, I moved the textbox position up a bit and the font automagically corrected itself. I tried adjusting the font in design and runtime, messing with the font of the frame, and replacing the textbox with a new one, but nothing seems to correct the font. I noticed the font in one textbox was different than the rest a bit slimmer, a hair shorter and more condensed than the default. I have a userform with several frames, labels, and textboxes, all set to a default font of Calibri Regular size 10. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |