Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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
0
Maliki Hassani
Asked:
Maliki Hassani
  • 8
  • 6
1 Solution
 
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
 
dlmilleCommented:
PS - you might want to pull the .txt file into a word document.

dave
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
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
 
dlmilleCommented:
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
 
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

Featured Post

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.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now