Results 1 to 3 of 3

Thread: VBA code to wrap text?

  1. #1
    Join Date
    Oct 2006
    Location
    Texas
    Posts
    1

    VBA code to wrap text?

    I didn't find a search on this forum. Hope I'm not asking something that has already been addressed here.

    Is there a way using vba to set some or all of the columns to automatically wrap text, similar to the Excel functionality? I was shocked at Microsoft's suggestion to do it one row at a time. There are hundreds of tasks already in my project.

    While I'm asking the question, is there also a way to word wrap the memo field, or does it word wrap when printing already?

    Thank you.

    glr

  2. #2
    Join Date
    Sep 2005
    Posts
    175

    Re: VBA code to wrap text?

    Yes, you can do it but remember that the Project only wraps fields that contain a space in the text string. Also it will work with row height and will not call it "text wrap". So, however you can do it using VBA I don’t think it is really worth to write code just for that. As far as your second query is concerned do you mean ‘Notes field’ for the term ‘memo’? If yes, then the best way to get the Notes field to print fully is to use File/Page Setup/View tab and set the option to print notes.

  3. #3
    Join Date
    Sep 2008
    Posts
    1
    Try using
    Worksheet.Cells.WrapText =true
    to wrap all the cells.

    (Hope this works!!!)

    Regards,
    Renu

Similar Threads

  1. How to text wrap with label in winforms
    By G. Kushal in forum Software Development
    Replies: 3
    Last Post: 14-07-2009, 10:23 AM
  2. How to word wrap text in Powerpoint
    By jeffcoo in forum Windows Software
    Replies: 3
    Last Post: 12-06-2009, 12:06 PM
  3. How to Wrap Text in Cells of Excel 2007
    By Leonard in forum Windows Software
    Replies: 3
    Last Post: 25-04-2009, 10:27 AM
  4. Insert image in text box with word wrap
    By IpsA in forum MS Office Support
    Replies: 2
    Last Post: 25-05-2008, 01:07 PM
  5. In HTML table how can I wrap the text ?
    By Matellis in forum Software Development
    Replies: 5
    Last Post: 20-05-2008, 07:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,639,805.62689 seconds with 17 queries