Excel VBA 2007: Modify code for scrolling feature for all listboxes in spreadsheet

Experts,

I was able to get a scrolling feature with the mouse over my listbox1.  However, I have 2 more listbox that are named 2 and 3 which are not coded to work.  The code is definitely beyond skill level.  If I can have someone review the coding to have all 3 of the listboxes work like listbox1, I would be so grateful. NOC-Reports-r23.xlsm
Maliki HassaniAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dlmilleConnect With a Mentor Commented:
I've re-integrated the code with your latest version, had to regenerate the primary listboxes in.  Let me know if it functions properly.

Dave
NOC-Reports-r24.xlsm
0
 
dlmilleCommented:
In the Executive Rollup, I've created hooks for LB2 and LB3 - let me know if they work.  That same code should be able to be used for your other summary charts.

See attached documentation (lance.txt) on this and some housekeeping items.

Dave
NOC-Reports-r23.xlsm
LANCE.txt
0
 
dlmilleCommented:
>>let me know if they work.

What I meant to say (they work for me) - let me know if they work for you.  I had to re-create a couple listboxes as they stopped working properly, sorry if my font/other display setting is off :)

dave
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dlmilleCommented:
PS - you might want to pull the .txt file into a word document.

dave
0
 
Maliki HassaniAuthor Commented:
Issue:  It scrolls but now it doesn't allow me to click in the listboxes.  I may need to strip your code and insert it into my newest file.  I did that yesterday night and everything worked.
0
 
Maliki HassaniAuthor Commented:
Working on answering your questions...
0
 
dlmilleCommented:
Yes - I had that andn had to delete the listboxes and recreate them.  I think if you just pull the code you'll be just fine...
0
 
dlmilleCommented:
I'm doing that now - hang...

Dave
0
 
Maliki HassaniAuthor Commented:
Please see attached file with comments..
LANCE-COMMENTS.txt
0
 
Maliki HassaniAuthor Commented:
Sa-Weet .. checking now!
0
 
dlmilleCommented:
When you get to a stable place, let's work the Application.EnableCancelKey = xlDisabled into all the right places.  I'm thinking of a clever way to do that.  But don't think we should dink with that until stabilized, as its a documented problem with a documented "fix" - short of putting this command at the top of each macro, I'm thinking on a better solution...

Dave
0
 
Maliki HassaniAuthor Commented:
Oh yeah!  Works like a charm!!  I don't see where I should have anymore issues with pertaining to this question.  It should only be a matter of taking the ListBox_MouseMove  1-3 into the rest of the sheets to function properly.  I will wait for you to respond before I close out. :)
0
 
Maliki HassaniAuthor Commented:
Okay, makes sense!
0
 
dlmilleCommented:
Sounds good.

Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.