Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag for United States of America

asked on

Tiny listbox fonts

Folks,
I thought I had a solution to maintining the size of my ListBox fonts but I'm having a problem still.
My attached workbook opens to a tab named "Menu" which populate two of my three list boxes. The text in the first two list boxes is tiny. Here's how this works. Select a Category and then Select a Topic, which once selected will populate the third ListBox Description. The third list box size is OK. But my problem is with the first two ListBoxes.
I recall that Excel has a "quirk" with ListBox fonts? I'm not sure if my problem is workstation dependent or not. If others do not get the problem I have then maybe this a workstation issue.
The font size for the all three Listboxes are the same as is the font type.
Excel-Formulas-and-Functions.xlsm
SOLUTION
Avatar of John
John
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank Freese

ASKER

If you change the size of the ListBoxes slightly the fonts are restored to their correct size. Weird
thanks - but a weird problem
appreciate you all
Yes cause it triggers a repaint and refresh event which causes the correct settings back.
gowflow
@fh_freese - Thanks and I was happy to help.

... Thinkpads_User