comment box internal formatting code

[sadams1]

Is it possible to reveal the codes for a comment box internal text formatting? What I've found so far deals mostly with bold or italic formatting with VBA but what I'd like to see is the spacing and hard returns between words.

 

[Norie]

Can't you just look at the ASCII values of the string in the comment box?

 

[sadams1]

Can't you just look at the ASCII values of the string in the comment box?

hello Norie & thank you for the reply! I have little if any experience with ASCII but found this chart:

http://access-excel.tips/excel-vba-asc-function-get-ascii-value-text/


Is this what I'd use to parse the code in VBA?

 

[Norie]

You would use that to tell you what interpret what each character in the text from the comment box represented.

To actually parse the text you would need a loop or functions to search/split things up.