Scrolling down my drop down box

[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

 

[Jacob Skaria]

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

 

[T. Valko]

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.

 

[Jacob Skaria]

Oops..I misread and thought scrolling down is the issue mentioned
here..Thanks Biff

 

[Dave Peterson]

Check your other post.

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