Excel Count characters in a textbox to display character count?
 

Hey,

How do I make it so Excel VBA counts the characters in a textbox
and displays a value in a message box? Thanks!

Excel Count characters in a textbox to display character count?
 

If you mean a textbox from the drawing toolbar, this will do it:

MsgBox Worksheets(1).TextBoxes("Text Box 1").Characters.Count

hth,

Doug

wrote in message
ups.com...
Hey,

How do I make it so Excel VBA counts the characters in a textbox
and displays a value in a message box? Thanks!