Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL 97 Text Box property - WordWrap

Status
Not open for further replies.

dipitiduda2

Technical User
Mar 17, 2003
18
US
I'm running Windows 98, XL97 for a workbook with password protection at VBA
ThisWorkbook level. I have a text box contol embedded in a cell with max row
height on cell set at 409. Text box format control is set to 'move and size
with cells' and PrintObject = True. Properties for text box are also set to
True for: EnterKeyBehavior, MultiLine, TabKeyBehavior, and WordWrap; False
for: ScrollBarsBoth, AutoSize, DragBehavior, and SelectionMargin.

The problem is that when a user types text into the control and selects
PrintPreview or actually prints the document, the data within the text box
(if more than one line of text) does not wrap around properly. Some of the
text wraps, but cuts off other text that should have wrapped, as well. Also,
when the text box control = GotFocus, the text appears visually as it should
look on PrintPreview or on Print command.

I have tried every combination for the text box control available. I truly
am at a loss here! Is this something that has to be handled in VBA? Thanks.

Please help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top