Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 698
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can I autopopulate from a long drop down list in Excel? seve Excel Worksheet Functions 2 February 11th 10 02:48 PM
Quick Find in long drop down list Candyman New Users to Excel 3 May 30th 08 06:29 PM
Using Look in-Drop down takes long to open a folder Firebird Excel Discussion (Misc queries) 2 December 19th 07 08:16 AM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
Setting up a random list from long list of names ? yorkshire exile Excel Discussion (Misc queries) 4 January 6th 05 01:44 PM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"