View original (French)

Expanding the dropdown list window

Loupmia Posted messages 10 Status Membre -  
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   -
Hello,

I’ve been searching online but I can’t find an answer to my problem…
I’m using a dropdown list for my purchase orders, however I would like to know if it is possible to enlarge the dropdown window so that I can view all the products instead of "scrolling" through my list?

Thank you.

2 réponses

Réponse 1 / 2
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Hello,

With a dropdown list of the form type or ActiveX type, it is possible to set the number of lines displayed by the list; however, when the number of values exceeds the number of lines, the scrollbar appears automatically.

Sincerely,
Patrice
0
Loupmia Posted messages 10 Status Membre
 
Hello Patrice,
How do you set the number of lines?
And another question, how do you make the list always start from the beginning and not from the end?
Thank you in advance

loupmia
0
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781 > Loupmia Posted messages 10 Status Membre
 
Re,

Form type list: Set the Number of Lines property (8 by default):

ActiveX type list: Set the ListRows property (8 by default)
0
Loupmia Posted messages 10 Status Membre
 
Re Hello Patrice,
I'm in the dark...I don't quite understand your response...or rather I don't know the "way" to access the NB property of lines, I don't know where I should change those settings...
0
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Hi,

I only have Excel 2003 on this machine but if I remember correctly:

Developer tab / insert a control

If the Developer tab is not visible, check in the Excel options.
0