Basically, it will define the current position of the scrollbar. The current Value field defines the current value of the scrollbar. In the above box, there are the following options: This will open a dialogue box as shown below: In this section, we will understand a few properties of ScrollBar.Īfter inserting the scroll bar based on the instructions explained in the previous section, just right click on the scroll bar and select the FORMAT CONTROL option: If the rectangle is spread more vertically, then a vertical scrollbar will be inserted in Excel. If you will move the rectangle spread more horizontally, then the Horizontal Scroll Bar control will be inserted in Excel.
Click on the Excel Ribbon, then select the Developer tab.Click on the Excel option to bring up the Excel Options dialog box.To get the Developer tab, follow the below steps: You can download this Scrollbar Excel Template here – Scrollbar Excel Templateįirst, you need to enable the Developer tab visible on the ribbon so you can get to the VBA and the ActiveX control commands.
