View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete[_22_] Pete[_22_] is offline
external usenet poster
 
Posts: 31
Default Can't wordwrap the contents of a text box

I wonder if the experts out there are aware of this little problem

Excel ver 2003

I have a form which has a Textbox with the WordWrap propertiy set to "True."

When I run the form, text that is imported will not 'wrap' as required,
remaining on a single line, despite the text box having a height of 45

I have tried putting in the following code just before loading the form:

frmQuestionComposer.TBoxQuestion.WordWrap = True

It make no difference! Text stubbornly remains on a single line half hidden
You have to enter the text box, and take your cursor to the end of the text
to read it all.

Is this 'bug' ?

Thanks,
Peter Bircher