+ Reply to Thread
Results 1 to 6 of 6

Add a scroll arrow to an Active X combo box

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Add a scroll arrow to an Active X combo box

    I have an application were I would like to use an Active X combo box instead of a regular dropdown list. The list contains 64 items and the text becomes very small in a standard dropdown list. Using an Active X Combo Box allows me to enlarge the text for easier viewing but with 64 items the list tends to run off the sheet. Is their a switch or some other way (scrolling) to make it more viewer friendly?

    Jim O


    Since their appears to be no further thoughts on this I will consider it solved.
    Last edited by JO505; 03-20-2013 at 04:30 PM.

  2. #2
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Add a scroll arrow to an Active X combo box

    Using an ActiveX combo box will do the job.. In the properties change the List Rows to the number of rows you want to show up...

    Jason

  3. #3
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Add a scroll arrow to an Active X combo box

    Hi!

    Using an ActiveX combo box will do the job.. In the properties change the List Rows to the number of rows you want to show up...

    Jason

  4. #4
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Add a scroll arrow to an Active X combo box

    Jason,

    I have the setting set for 64 rows but I still cant see all of the list as I can in a standard dropdown. I can use the up and down keys to scroll through the list one at a time but I would like to be able to see more of the list at a single viewing. I dont know if this is possible or not, my gut feeling is that it is not possible.

    Jim O

  5. #5
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Add a scroll arrow to an Active X combo box

    I have switched to an Active X List Box and that seems to do the job. I anyone has anything to add I am open to all suggestions.

    Jim O

  6. #6
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Add a scroll arrow to an Active X combo box

    Quote Originally Posted by JO505 View Post
    I would like to be able to see more of the list at a single viewing.
    Hi!
    Change the ListRows to 20 or 25 depending on how much of the list you want to see...

    Jason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1