Scrolling down my drop down box

  • Thread starter Thread starter MAC MAN
  • Start date Start date
M

MAC MAN

I have approximately 1500 rows in my validation list for products I want to
select however when I use my drop down box I can only scroll down to about
1025 rows and the scrolling stops. How can I resolve this problem as the
limitations on the number of rows in a list are almost infinite (65,000 or so
from what I have read in your discussion group.
Any help would be appreciated
I use Office for Mac 2008
Bob
 
A drop down box has got this limitations..Instead from menu
View>Toolbars>Control Toolbox>select 'ComboBox' place this over a cell. While
in design mode right click the 'combobox' control and select 'Properties' and
set the below properties . Once done click the first icon in the 'Control
Toolbox' to 'Exit Design mode'.

Linked cel. (eg" Sheet1!C1)
List Rill Range (eg: Sheet1!A1:A2500)

If this post helps click Yes
 
A drop down box has got this limitations..

The limit is 32,767 items (from a range).

That's pretty big for a drop down list.
 
Oops..I misread and thought scrolling down is the issue mentioned
here..Thanks Biff
 
Check your other post.

MAC said:
I have approximately 1500 rows in my validation list for products I want to
select however when I use my drop down box I can only scroll down to about
1025 rows and the scrolling stops. How can I resolve this problem as the
limitations on the number of rows in a list are almost infinite (65,000 or so
from what I have read in your discussion group.
Any help would be appreciated
I use Office for Mac 2008
Bob
Click to expand...
 
Back
Top