ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   My list is too long for my drop down box (https://www.excelbanter.com/excel-programming/359409-my-list-too-long-my-drop-down-box.html)

ToferKing

My list is too long for my drop down box
 
I have a list of 70 pieces of equipment. I have created a combo box to
display them, but the combo box shows only 67 of them. It does not have a
slide bar on the right side of the drop down list to drag down to see the
rest of the units, how do I get a slide bar in my drop down list?

Thanks, Tofer

L. Howard Kittle

My list is too long for my drop down box
 
You could use a drop down from Data Valaditation. Seems to hold and
indefinite number of entries.

HTH
Regards,
Howard

"ToferKing" wrote in message
...
I have a list of 70 pieces of equipment. I have created a combo box to
display them, but the combo box shows only 67 of them. It does not have a
slide bar on the right side of the drop down list to drag down to see the
rest of the units, how do I get a slide bar in my drop down list?

Thanks, Tofer




ToferKing

My list is too long for my drop down box
 
LHK,
Thanks so much for the suggestion. I do need a drop down box and I did fix
the problem by indicating in the properties section that the list should show
50 items. The slide bar showed up and all of the items can be viewed now.

Tofer

"L. Howard Kittle" wrote:

You could use a drop down from Data Valaditation. Seems to hold and
indefinite number of entries.

HTH
Regards,
Howard

"ToferKing" wrote in message
...
I have a list of 70 pieces of equipment. I have created a combo box to
display them, but the combo box shows only 67 of them. It does not have a
slide bar on the right side of the drop down list to drag down to see the
rest of the units, how do I get a slide bar in my drop down list?

Thanks, Tofer






All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com