You could use a textbox to display the input message. There's an example
he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Input Message in Textbox'

arnoldarmy wrote:
Hi

I tried this a fewmonths ago - having a similar problem in wich the actaul
size of the drop down list of validated entres varies from sheetto sheet - so
on some workseets you can read 30 charcters and on the next (identical)
worksheet you can on see 15 characters.
Apparantly, there is no way to change this - I have scouted round the excel
experts' sites to know avail -
I would be ver intersted if anyone elscan find a solution.
thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html