I have a spreadsheet with a drop-down list box. I'm having issues that seem
to be compounded as indicated below...
€¢ The cell width for each column is very limited and the width of the items
in the cell work only with the font size of 8 or less.
€¢ The drop-down list has 14 items. This causes a scroll bar in the drop-down
and further impacts the issue above so that not all content can be viewed€¦

Any ideas??

Drop down rows is a property you can change. Right click the control and
pick Properties and modify ListRows if this control is from the Control
Toolbox toolbar. If it's from the Forms toolbar right click it, pick Format
Control, and change Drop down lines on the Control tab.

I don't know what you want for the first conundrum. If you can't use a
small enough font and can't widen columns I guess you have to shorten the
text.

--
Jim
"Roberta" wrote in message
...
|I have a spreadsheet with a drop-down list box. I'm having issues that seem
| to be compounded as indicated below...
| . The cell width for each column is very limited and the width of the
items
| in the cell work only with the font size of 8 or less.
| . The drop-down list has 14 items. This causes a scroll bar in the
drop-down
| and further impacts the issue above so that not all content can be viewed.
|
| Any ideas??
|