Convert Character Count to Twips

bradyboyy88

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?
 

RoryA

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

shg

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

Top