Convert Character Count to Twips


Well-known Member
I am trying to solve a problem. Assume I have a label that is 100 twips in width (default unit from my research) for a userform. I need to count how many characters of a specific font can fit into that 100 width without going to a new line. That would require converting these units of measure and I cannot seem to figre it out. ANy ideas?


MrExcel MVP, Moderator
Is it a fixed width font? If not, all the characters are different widths...


MrExcel MVP
Put a string in a cell, autofit the column width, and check the width?

I get 103.7 twips/character for Consolas 9pt.
Last edited:

Some videos you may like

This Week's Hot Topics