+ Reply to Thread
Results 1 to 5 of 5

Utilizing the middle scroll on a mouse in VBA

  1. #1
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    Utilizing the middle scroll on a mouse in VBA

    Hi,
    Is there any way to activate the middle scroll when using combobox's on userforms?

    I've seen a few links where there is a long and elaborate process to do so, but then its only installed on one computer, and I need it to work no matter where the file is opened.

    Thanks.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Utilizing the middle scroll on a mouse in VBA

    it is possible to use api calls in the file but it seems like a lot of effort when comboboxes automatically match as you type anyway ;-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    Re: Utilizing the middle scroll on a mouse in VBA

    Yeah, Ive considered not going through the effort, but I'm creating this file for users who aren't too familiar with excel, (or anything too technical to be honest). So I just thought itd be nice for them.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Utilizing the middle scroll on a mouse in VBA

    you will require something like this: http://www.xtremevbtalk.com/showthread.php?t=178071
    I have not tested with a combobox but know it worked with a listbox

  5. #5
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    Re: Utilizing the middle scroll on a mouse in VBA

    Hmm, My excel file crashes every time I try to run it. It seems like too much of a hassle. Thank you for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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