+ Reply to Thread
Results 1 to 2 of 2

Allowing Multiple Lines Per Cell Without Alt+Enter

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Texas, USA
    MS-Off Ver
    Excel 2008
    Posts
    1

    Allowing Multiple Lines Per Cell Without Alt+Enter

    Is there a macro/code to format a cell to allow multiple lines to show in a single cell? It is general text and should appear as a list. It would be great if Enter prompted the next line.

    I am new to the forum and coding/macros, so explicit instructions please. Thanks for your help!

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Allowing Multiple Lines Per Cell Without Alt+Enter

    I think this will do what you want. Put the code behind the worksheet where you want it to apply. To exit from the cell you're editing, hit Enter twice, or hit Esc.
    Please Login or Register  to view this content.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ 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. Allowing user to enter either percentage or number
    By Destruction in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2011, 09:36 AM
  2. Allowing for variable lines in macros
    By smurrock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2006, 11:55 AM
  3. [SOLVED] 30-yr Amortization allowing 26 payments per year/780 lines vs 360
    By vbpatton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2006, 09:50 AM
  4. [SOLVED] Not allowing users to enter data into certain cells if another cell is empty
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-06-2005, 02:06 PM
  5. [SOLVED] how do I enter multiple lines in a cell in Excel
    By asowles in forum Excel General
    Replies: 2
    Last Post: 02-03-2005, 04:06 PM

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