Frank Freese
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks - but a weird problem
appreciate you all
appreciate you all
Yes cause it triggers a repaint and refresh event which causes the correct settings back.
gowflow
gowflow
@fh_freese - Thanks and I was happy to help.
... Thinkpads_User
... Thinkpads_User
ASKER