Excel: Listboxes automatically fire when I scroll over the box

Experts,

This is a question to chain of modifications to my Dashboard.  An issue that I found is that when I scroll over any listbox in the spreadsheet, it automatically fires the command (double clicks).  It should only allow the mouse pointer to begin the mouse scroll, nothing more.

Any ideas?       NOC-Reports-r28.xlsm
Maliki HassaniAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
I think I know what you mean but that is because you have specified it that way :)

The ListBox1_LostFocus event will fire every time you select it and then move the focus away from ListBox1

Sid
0
 
SiddharthRoutCommented:
It doesn't for me...

Sid
0
 
Maliki HassaniAuthor Commented:
Sid:  I believe if you select an id and scroll over a different listboxes this triggers it.
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.