Thread: Excel Count characters in a textbox to display character count?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy[_7_] Doug Glancy[_7_] is offline
external usenet poster
  
Posts: 55
Default 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!



Reply With QuoteReply With Quote