Open Excel, then the VBA editor, then Add-Ins->Add-In Manager. VB.Net - ScrollBar Control. The ScrollBar controls display vertical and horizontal scroll bars on the form. This is used for navigating through large amount of information. There are two types of scroll bar controls HScrollBar for horizontal scroll bars and VScrollBar for vertical. Public Const MOUSEEVENTFLEFTDOWN &H2 Public Const MOUSEEVENTFLEFTUP &H4 Public Const MOUSEEVENTFRIGHTDOWN As Long &H8 Public Const MOUSEEVENTFRIGHTUP As Long &H10 Set Mouse Position Public Sub SetCursorPosition() &x27;Reset mouse event mouseevent MOUSEEVENTFLEFTDOWN, 0, 0, 0, 0 &x27;Set cursor position constants Dim oLeft As Long oLeft 10. If you scroll by clicking on the scroll bar, you will receive two events the normal UpDownLeftRight by PageLine event followed by and EndScrollHorizontalScroll or a EndScrollVerticalScroll event. If you scroll by dragging the button in the scrollbar, you will receive only the EndScrollHorizontalScroll or EndScrollVerticalScroll event. Interactive Chart on Mouse Hover. In this article, we will discuss how to create a chart and change the series & it's value on mouse hover. Though, there is no Mouse Hover event in Excel however, we will use an alternate method to simulate Mouse Hover event and change the series of a line chart. You can apply the same tips for other charts or. 1- Add this code behind your UserForm Private Sub UserFormInitialize () HookFormScroll Me End Sub Private Sub UserFormQueryClose (Cancel As Integer, CloseMode As Integer) UnhookFormScroll End Sub. 2-Add one of the following to a Module depending on your office architecture. If Office is on 32 bit.