Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Combobox

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My combobox scroll bar is not moving when I need a list of all the data in a column
    (Row Source = B:B)
    It only moves when I list a small amout of data
    (Row Source = B1:B22)

    How can I solve this problem???
    Thanks in advance

  2. #12
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Allen


    My example will also work for a ComboBox in the same way! It will sort alphabetically and remove duplicates.

    Rather than use an entire Column as a RowSource use a Dynamic range. These are ideal for the RowSource of Controls.
    http://www.ozgrid.com/Excel/DynamicRanges.htm

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •