Convert Character Count to Twips

[bradyboyy88]

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]

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

 

[bradyboyy88]

Yea I am only using monospaced fonts which are fixed width.

 

[shg]

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

I get 103.7 twips/character for Consolas 9pt.

 

[bradyboyy88]

Great idea. I feel dumb seeing how simple that was haha.