ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scroll bar - Control Toolbox (https://www.excelbanter.com/excel-discussion-misc-queries/69337-scroll-bar-control-toolbox.html)

olstrain

Scroll bar - Control Toolbox
 
How do I connect this scroll bar to certain cells.
I saw someone who had this done and as they scrolled left or right, the
values changed in teh cells - depending on what was set in teh Properties
window.
I can't figure out how to do that.


Dave Peterson

Scroll bar - Control Toolbox
 
If the scrollbar is from the forms toolbar, you can right click on it and choose
format control. The look at the Control tab.

If the scrollbar is from the Control toolbox toolbar, click on the design mode
icon (also on that same toolbar), rightclick on the scrollbar and choose
properties.

You'll see linked cell, min, max, ...

olstrain wrote:

How do I connect this scroll bar to certain cells.
I saw someone who had this done and as they scrolled left or right, the
values changed in teh cells - depending on what was set in teh Properties
window.
I can't figure out how to do that.


--

Dave Peterson


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com