+ Reply to Thread
Results 1 to 3 of 3

How to reflect the line break in a cell

  1. #1
    Registered User
    Join Date
    03-27-2019
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    28

    How to reflect the line break in a cell

    Hi everyone

    I have inserted some line breaks in some cells through vba codes
    The line breaks are successfully inserted, however, they are not showing until you double click/press F2 on those cells

    I tried cells.select, sendkeys "{F2}", but it doesn't help to show the line break automatically after ran the vba codes.

    Thank you all if you can give me a help for this, cheers

    bb1228
    Last edited by AliGW; 07-16-2022 at 12:10 AM.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,187

    Re: How to reflect the line break in a cell

    Are the cells formatted with the "Wrap Text" option? I don't think you see line breaks unless you have this option enabled on the cells. Select the cell, press Ctrl+1, go to the Alignment tab and enable "Wrap text". Does that work?

    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    03-27-2019
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    28
    Quote Originally Posted by WideBoyDixon View Post
    Are the cells formatted with the "Wrap Text" option? I don't think you see line breaks unless you have this option enabled on the cells. Select the cell, press Ctrl+1, go to the Alignment tab and enable "Wrap text". Does that work?

    WBD
    Thank you WBD

    Itís worked after I added the wraptext code.
    Cheers😊

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 05-30-2018, 01:03 PM
  2. VBA changes to reflect break out of Total charges
    By detrw4always in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2016, 08:05 AM
  3. Line Break in a cell
    By anmck in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 03:33 PM
  4. [SOLVED] Break cell into multiple lines by line break
    By Chia in forum Excel General
    Replies: 1
    Last Post: 08-20-2006, 01:40 AM
  5. [SOLVED] line break in a cell-Is there a way to get the line break instead of a symbol?
    By luvgreen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2005, 02:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1