Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Data Validation Input Message Box too small

I have entered a message in the box but not all of it appears when the cursor
is placed on the cell. How can I enlarge the box to view the entire contents?
I have tried adding spaces <ENTER with no success.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,117
Default Data Validation Input Message Box too small

i have entered large amounts of text into a data validation input
message box, with all of it showing (including returns). are you sure
you're not typing in the one-line "title" box? instead of the multi-
line "input message" box?
just an idea
susan


On Jun 9, 8:36*am, Joe wrote:
I have entered a message in the box but not all of it appears when the cursor
is placed on the cell. How can I enlarge the box to view the entire contents?
I have tried adding spaces <ENTER with no success.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Data Validation Input Message Box too small

The input message can be up to 255 characters, but will only display
about 12 rows of text. If you have too many line breaks, that might be
the problem.
There's no way to adjust the size of the input message box.
Perhaps you could add a comment to the cell, and put the text there.


Joe wrote:
I have entered a message in the box but not all of it appears when the cursor
is placed on the cell. How can I enlarge the box to view the entire contents?
I have tried adding spaces <ENTER with no success.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - input message yshridhar Excel Discussion (Misc queries) 0 January 28th 08 05:22 AM
Data Validation Input Message Klee Excel Discussion (Misc queries) 12 May 6th 07 01:24 PM
Data Validation Input Message Sandy Excel Worksheet Functions 1 March 8th 06 03:19 PM
DataValidationInput message irresistible007 Excel Worksheet Functions 1 December 3rd 05 01:06 PM
Input message on data validation field Russell-stanely Excel Discussion (Misc queries) 1 August 5th 05 02:41 AM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"