+ Reply to Thread
Results 1 to 4 of 4

mousewheel work on combobox

  1. #1
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    mousewheel work on combobox

    Hi all,
    I have a combobox in a userform that has around 150 entries. Can I make use of scrollbar in that combobox?

    Thanks & Regards,
    Vaibhav

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: mousewheel work on combobox

    Good evening c.vaibhav
    Quote Originally Posted by c.vaibhav View Post
    I have a combobox in a userform that has around 150 entries. Can I make use of scrollbar in that combobox?
    There's a discussion about the scroll wheel here - installing one of the little apps discussed will allow the scroll wheel to work within the VBE, but I'm not sure if it will extend to the userform controls.

    However, there's a solution posted here which uses code originally devised by API God Jaafar Tribak and posted here. Just be aware that it uses mousehooks and callbacks and other unsavoury techniques which may just crash your machine, so exercise caution and ensure you have saved your work.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: mousewheel work on combobox

    Hello c.vaibhav ,

    Microsoft has created an Add-In (executable) program to fix this problem. You can read how to install it step by step by clicking the link below...

    Add support for the scroll wheel to the Microsoft Visual Basic for Applications 6 environment
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: mousewheel work on combobox

    Thanks for your reply..

    I'll check out the link that you have posted..

    Regards,
    Vaibhav

+ 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