<div>
Hi satmisha<br />
<br />
Sorry but there is not way to resize a drop down menu.<br />
The resizing would work for filter options but not drop down.
</div>


Hi satmisha

Sorry but there is not way to resize a drop down menu.
The resizing would work for filter options but not drop down.

<div>
Can you use a VBA combobox instead? &nbsp;If you can, you can specify how many rows you want to see.<br />
<br />
Ex:<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/03_w11/903286/drop-down-menu.jpg" target="_blank" title="Combobox (87 KB)"><img alt="Combobox" class="file-block lazyload" style="max-width: 566px;" data-src="https://filedb.experts-exchange.com/incoming/2015/03_w11/903286/drop-down-menu.jpg" /></a>
</div>


Can you use a VBA combobox instead?  If you can, you can specify how many rows you want to see.

Ex:
Comboboxhttps://filedb.experts-exchange.com/incoming/2015/03_w11/903286/drop-down-menu.jpg

drop-down-menu.jpg

<div>
Thanks Jean-Marc (Wilder1626) for your quick reply.<br />
<br />
My requirement is only for Data Validation drop down.
</div>


Thanks Jean-Marc (Wilder1626) for your quick reply.

My requirement is only for Data Validation drop down.

Data-Validation-vs-Combobox.xlsm

<div>
Superb man. Thanks a lot for your quick reply.
</div>


Superb man. Thanks a lot for your quick reply.

<div>
<div class="content wysiwyg-content">
Hi Expert,<br />
I want to see more than eight items at a time in the data validation dropdow,, as of now only eight items one can see.<br />
<br />
Is there any way to achieve this without using activeX ctrls ? Attaching file for your reference.<br />
<br />
Looking forward to hearing from you.
</div>
</div>


Hi Expert,
I want to see more than eight items at a time in the data validation dropdow,, as of now only eight items one can see.

Is there any way to achieve this without using activeX ctrls ? Attaching file for your reference.

Looking forward to hearing from you.

Way to incorporate more than Eight Items in Data Validation drop down

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.