![]() |
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 |
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 |
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