Something as shown below:

The idea is to display the value right next to the Excel scroll bar, rather than having it somewhere in the back-end. This way the user can play with the data more effectively.

Try it yourself.. Download the file Enjoyed this tutorial? You might also like these:

Using Scroll Bar in Dynamic Charts. Creating Drop Down list with Search Suggestion in Excel. Creating Dynamic Filter in Excel. Inserting and Using Checkboxes in Excel.