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

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.
satmishaAsked:
Who is Participating?
 
Wilder1626Commented:
Ok.
In this case, this is not possible to do with a Data Validation drop down menu.

In case you change your mind, here is both options. Data Validation versus Combobox in the excel attachment.
Data-Validation-vs-Combobox.xlsm
0
 
Wilder1626Commented:
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.
0
 
Wilder1626Commented:
Can you use a VBA combobox instead?  If you can, you can specify how many rows you want to see.

Ex:
Combobox
0
 
satmishaAuthor Commented:
Thanks Jean-Marc (Wilder1626) for your quick reply.

My requirement is only for Data Validation drop down.
0
 
satmishaAuthor Commented:
Superb man. Thanks a lot for your quick reply.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.