Results 1 to 18 of 18

Get Find and mouse wheel scroll working in list box

Threaded View

taralmehta15 Get Find and mouse wheel... 07-16-2015, 08:42 AM
LordLoki Re: Get Find and mouse wheel... 07-16-2015, 09:19 AM
taralmehta15 Re: Get Find and mouse wheel... 07-16-2015, 09:51 AM
LordLoki Re: Get Find and mouse wheel... 07-16-2015, 10:45 AM
taralmehta15 Re: Get Find and mouse wheel... 07-16-2015, 11:27 AM
LordLoki Re: Get Find and mouse wheel... 07-16-2015, 02:37 PM
taralmehta15 Re: Get Find and mouse wheel... 07-16-2015, 04:15 PM
LordLoki Re: Get Find and mouse wheel... 07-16-2015, 05:24 PM
LordLoki Re: Get Find and mouse wheel... 07-16-2015, 05:40 PM
taralmehta15 Re: Get Find and mouse wheel... 07-17-2015, 01:55 AM
LordLoki Re: Get Find and mouse wheel... 07-17-2015, 03:11 AM
LordLoki Re: Get Find and mouse wheel... 07-17-2015, 03:59 AM
taralmehta15 Re: Get Find and mouse wheel... 07-17-2015, 07:43 AM
LordLoki Re: Get Find and mouse wheel... 07-17-2015, 07:51 AM
taralmehta15 Re: Get Find and mouse wheel... 07-21-2015, 04:29 AM
LordLoki Re: Get Find and mouse wheel... 07-21-2015, 06:55 AM
LordLoki Re: Get Find and mouse wheel... 07-21-2015, 07:20 AM
taralmehta15 Re: Get Find and mouse wheel... 07-21-2015, 08:14 AM
  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    ahmedabad
    MS-Off Ver
    Excel 2007
    Posts
    59

    Get Find and mouse wheel scroll working in list box

    Hi Friends,
    I have a sheet in which I select products from listbox and extract it to the columns.(Sample sheet attached.) Having a few difficulties as follows:

    1- listbox doesnt work if I save the file with that particular sheet active. For eg: my listbox is in the sheet named 'order'. If i save the file with cell in that sheet, next time when I open the file ('order' sheet will be displayed as dat was the 1 while savin the file), listbox wont work. I have to select other sheet and then go back to the 'order' sheet to get listbox working.

    2- I have around 4500 products and it becomes very difficult to find a particular product from it. (Although I have it sorted alphabetically but still, its huge list). I woud prefer if i can find products by typin a few words (filtering as i type).

    3- I am not able to use mouse wheel to scroll through the list box.

    I would really appreciate if ne1 can help me in solving this (or suggest a workaround to make it easier). I dunno much about vba. Have learnt a bit through dis forum and google only. Hence, Please mention a bit in detail if I have to modify the vba or nethin such..
    Thanx a lot..
    Attached Files Attached Files
    Last edited by taralmehta15; 07-27-2015 at 08:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Validation Lists - Mouse scroll wheel
    By camz100 in forum Excel General
    Replies: 1
    Last Post: 02-17-2012, 06:56 PM
  2. Scroll horizontally with a mouse wheel
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2010, 11:16 AM
  3. Scroll with mouse wheel on userform
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2007, 08:19 PM
  4. [SOLVED] How do I turn off MS mouse wheel scroll?
    By MrBill in forum Excel General
    Replies: 8
    Last Post: 07-20-2006, 01:45 PM
  5. [SOLVED] Wheel on mouse doesn't scroll in VB
    By Nolan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-12-2006, 08:35 AM
  6. [SOLVED] Using mouse wheel to scroll drop down
    By rfielack in forum Excel General
    Replies: 0
    Last Post: 01-14-2006, 06:10 PM
  7. scroll with wheel mouse
    By Scott in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2005, 04:05 PM
  8. scroll listbox with mouse wheel
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2005, 05:55 PM

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