View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default TRYING FIGURE out how wide a text box should be in userform

Did you want the width of the TextBox to vary with the user's entry? If so,
set the AutoSize property to True.

--
Rick (MVP - Excel)


"Bruce" wrote in message
...
I am trying to create a form programically.

I have different varying lenth of fields. I am sure there has to be a way
to
calculate the width of the field, based on the font size and the number of
characters. Any ideas how to figure the width?

Thanks
Bruce