Data Validation Input Message Size

K

Kevlar

There is a limit to the size of the input message box that appears whe
you click on the cell with a data validation list. I'm not talkin
about the message itself (thats limited too, but thats not th
problem). I have 20 items listed in my Input message box but when yo
view the list it cuts off the last 9.

Is there a way to change the size of the box
 
D

Debra Dalgleish

The input message can be up to 255 characters, but will only display
about 10 rows of text. Instead of a single column, you could enter your
items separated by commas, or spaces.
 
D

Debra Dalgleish

You can't adjust the message length or height. Those settings are
assigned automatically.
 
Top