ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing a scrollbar value to 0 (https://www.excelbanter.com/excel-programming/282414-changing-scrollbar-value-0-a.html)

Nilrem[_3_]

Changing a scrollbar value to 0
 

How can I change the scrollbar value to 0 in a macro?
I've tried scroll bar 1.select and other variations of that to chang
the value but have had no succession

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com


Nilrem[_4_]

Changing a scrollbar value to 0
 

To explain myself better I'm trying to make a reset switch to reset th
values to 0. But because the scrollbar directly effects a cell I canno
just reset the cell to 0, but I need the scrollbar to be put back to
(as if it hasn't been moved at all)

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com



All times are GMT +1. The time now is 03:09 PM.

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