Coding 2 events at once?

LufiaMaxim

New Member
Joined
Jul 13, 2011
Messages
16
I'm using a scrollbar, and currently I have the same code for two events relating to that scrollbar - scrlbar_Change and scrlbar_Scroll

From my understanding the Change event captures events where the user clicks left or right on the scroll bar. The Scroll event captures when the user drags the scrollbar and moves it...

Is there an event to capture both when a user clicks or drags the bar? Or is there a way to capture Change & Scroll with the same line? I'm a fan of efficiency, and having two separate events with the same code seems inefficient to me.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
You could put the common code into a separate subroutine and call it from both scrlbar_Change and scrlbar_Scroll. If the behaviour needs to be changed at some future time you would need modify only the common subroutine.
 
Upvote 0

Forum statistics

Threads
1,224,552
Messages
6,179,486
Members
452,917
Latest member
MrsMSalt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top