I'm a bit curious.

Do you mean that the font size is too small to read, the number of
lines displayed in the list box is too few or the width of the list box
is too narrow to display each list item fully?

The third can be done by widening the column or merging columns. The
second is covered in the link to Debra Dalgleish's site - great site.
The first looks like a dead end.


--
Lost4Now
------------------------------------------------------------------------
Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
View this thread: http://www.excelforum.com/showthread...hreadid=495985