general question about measuring text inside comment boxes...

[sadams1]

In Word, you can the ruler to see measurements of tabs, indents & spacing. I know that the comment boxes in Excel do not have that capability. However, I'm fairly certain I have seen VBA code that does show measurements like this within comment boxes. Is there a "reveal codes" for text in comment boxes anything like this?

 

[Tom Urtis]

You can determine the size of a comment shape with a basic macro like this, assuming your comment is in cell A1:

Sub CommentSize()
With Range("A1").Comment.Shape
MsgBox "Height: " & .Height & vbCrLf & "Width: " & .Width, , "Comment size:"
End With
End Sub

Comment shapes are of the Points unit of measurement.
For example, one inch equals 72 points.

 

[PhilS2520]

Hey sadams1

OK, I am not sure I understand your question properly. By “measurement” you mean how much “space” that string will occupy? Or do you mean the number of characters in the string?

If you need the count of characters in a string look into the LEN() Function.

If you mean the “space” the string will occupy, I am afarid, as I understand things, there are other variables in play here. One major one will be the font used. Courier New is a font that uses the same “space” for all characters. The I and the H occupy the same space. There is a technical term to describe that kind of font, but I am drawing a blank right now.

If you are interested take a peek at https://creativemarket.com/blog/10-fascinating-scientific-facts-about-fonts or search using “all about fonts”

Hope this helps.