View original (French)

Expanding the dropdown list window

Loupmia Posted messages 10 Status Member -  
Patrice33740 Posted messages 8400 Registration date   Status Member 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 answers

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    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
    1. Loupmia Posted messages 10 Status Member
       
      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
      1. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784 > Loupmia Posted messages 10 Status Member
         
        Re,

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

        ActiveX type list: Set the ListRows property (8 by default)
        0
    2. Loupmia Posted messages 10 Status Member
       
      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
    3. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
       
      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