increase number of items shown in drop down list?

The responder gave you instructions for a ComboBox from the Control Toolbox.

You are using Data Validation dropdown list so won't have the "Format
Control"

DV dropdowns cannot be extended to show all items.

Perhaps you might want to use a ComboBox in conjunction with the DV.

In that case see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal14.html

Note: a ComboBox also gives you autocomplete function which DV cannot
provide.


Gord Dibben MS Excel MVP



On Wed, 11 Feb 2009 14:04:00 -0800, lenesila
wrote:

I tried this and no "Format Control" shows in the menu. I have office 2007.

"Jollymon67" wrote:

Rght click over the drop down menu. Select "Format Control" from menu. Click
on "Control" tab. You should see a line that says "Drop down lines:" and then
a box with a number in it. Increase the value of the number in this box to a
value equal to, or greater than the number of lines you need to display.
Select OK

"kojaks43" wrote:

Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k

Gord,

I have tried creating a Combo Box in Excel 2007 but cannot seem to find how
to change the font of the box contents nor start the auto-complete function.
Any ideas?

"Gord Dibben" wrote:

The responder gave you instructions for a ComboBox from the Control Toolbox.

You are using Data Validation dropdown list so won't have the "Format
Control"

DV dropdowns cannot be extended to show all items.

Perhaps you might want to use a ComboBox in conjunction with the DV.

In that case see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal14.html

Note: a ComboBox also gives you autocomplete function which DV cannot
provide.


Gord Dibben MS Excel MVP



On Wed, 11 Feb 2009 14:04:00 -0800, lenesila
wrote:

I tried this and no "Format Control" shows in the menu. I have office 2007.

"Jollymon67" wrote:

Rght click over the drop down menu. Select "Format Control" from menu. Click
on "Control" tab. You should see a line that says "Drop down lines:" and then
a box with a number in it. Increase the value of the number in this box to a
value equal to, or greater than the number of lines you need to display.
Select OK

"kojaks43" wrote:

Using Excel 2007 - Home edition.

Created a list and placed drop down using data validation.
The drop down window shows some of the entries with a scroll bar. Can I
increase the size of the drop down so the scroll bar goes away?

Thanks

k