Word wrap in drop down lists

[Mark Burstall]

I am using Excel from Office 97 in Windows XP.

I am developing a spreadsheet with a number of drop down
lists to enable the user to select pre-formatted text in a
protected worksheet. This will eventually be used on line.

The problem I have is that I cannot get the text to wrap
within the display box of the drop down list. The box is
not sufficiently wide to display it all but has plenty of
height, so could do if the text would wrap.

Any suggestions gratefully received.

Thanks and regards.

 

[Debra Dalgleish]

If these are data validation dropdowns, you could use a SelectionChange
event to temporarily widen the column. There are instructions here:

http://www.contextures.com/xlDataVal08.html#Wider

 

[AlanE]

Rather than using a drop-down list object, try using
Data-Validation-Allow:List. Then simply format that cell for text
wrap. If the range containing the list is on a separate sheet, give
that range a name so that you can easily reference it.