Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I autopopulate from a long drop down list in Excel? | Excel Worksheet Functions | |||
Quick Find in long drop down list | New Users to Excel | |||
Using Look in-Drop down takes long to open a folder | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) |