Thread: Text Box Length
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Text Box Length

The width (in points) will be returned by .Width property of the listbox.
Caution: if empty, the listbox seems to have a minimum width of 12.75
The width is dependent upon the characters' with with proportional fonts:
'0000000000 will give a larger width than iiiiiiiiii

HTH
--
AP


"CWillis" a écrit dans le message de
news: ...
I created a macro that auto sizes a text box. I would like for the macro
to
tell me the length of that text box. (I believe this is simply the number
of
characters in the text box.) How do I do this? Thanks in advance for any
suggestions.