+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Data Validation Input Message Box

  1. #1
    Registered User
    Join Date
    02-04-2011
    Location
    somewhere
    MS-Off Ver
    Excel 2007
    Posts
    16

    Data Validation Input Message Box

    Hello,
    I have been working with a Data validation input message box and it does not display my text correctly.
    for example what should be displayed all on one line goes to two lines.

    Is there a way to make the input message box bigger or a way to display my text all on one line.

    Here is a example of my text:
    12345 - Apples
    4567 - Oranges
    12348 - Pears

    when i type the input message text it displays like this:
    1234-
    Apples
    It jumps down a line instead of staying on one line

    Thanks for the help

  2. #2
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Data Validation Input Message Box

    can you post a sample of your validation as when I put message in it is all on one line

  3. #3
    Registered User
    Join Date
    02-04-2011
    Location
    somewhere
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Data Validation Input Message Box

    Attached is a copy of what my message box looks like, I would like for each item to be all on its own line.


    thanks for the help
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    02-04-2011
    Location
    somewhere
    MS-Off Ver
    Excel 2007
    Posts
    16

    Question Re: Data Validation Input Message Box

    any ideas why my input message box wont let each line text stay on the same line.

  5. #5
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Data Validation Input Message Box

    the message box only allows a certain number of Characters per line but if you right click on your cell and INSERT COMMENT you can stretch the box and put it all on one line

  6. #6
    Registered User
    Join Date
    02-04-2011
    Location
    somewhere
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Data Validation Input Message Box

    anyway to hide the red tick mark on the corner of the cell, when inserting a comment?

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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