XL 97 Text Box property - WordWrap

D

dipitiduda

Note: I also posted this thread in Excel Printing:

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB to set wordwrap on Control Toolbox Textbox 3
getting text out of TextBox into code 0
adding text boxes at runtime and setting autosize to True 0
Can't wordwrap the contents of a text box 2
Tab character in a Text Box 1
Eliminate blank row at top of Text Box entries 3
WordWrap a TextBox on a UserForm 2
Place Text box at Mouse Pointer Position on a page 0

Top