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
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
The fonts in the first two columns are smaller than the font in the third column. The third column is Calibri 11 point.

The first two columns are the same as my desktop fonts.

That is a long way of saying that I think the list box fonts are controlled by Windows rather than Excel.

What happens if you make the desktop fonts larger?

.... Thinkpads_User
0
NorieAnalyst Assistant Commented:
I'm also seeing different font sizes, even when I set them to be the same via the Property sheet of each listbox.

You could use Forms listboxes instead of ActiveX to get a uniform font size, but that is controlled by Windows settings I believe.
0
gowflowCommented:
Well is this what you want ??

Just few comments:
1) You do not have 3 list boxes as you mentioned in your post you have 2 listboxes and 1 label
2) The listboxes were found with Calibri 14 Regular where the label is at Calibri 14 Bold.

It seems your listboxes were a bit locked so what I did simply is to turn for a while IntegralHeight to true and ran your macro also had both listboxes to Calibri 14 Bold then as the listboxes were changing heights obviously because of the change in integralheight I set it back to False and resized them to be as they are now.

Try the file and let me know if it fixes your problem.
Some weird issues do happen in Excel .... need to live thru and around them !
Excel-Formulas-and-Functions.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

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

... Thinkpads_User
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.