ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scrollbar help (https://www.excelbanter.com/excel-discussion-misc-queries/126865-scrollbar-help.html)

[email protected]

Scrollbar help
 
I am trying to have a scrollbar that will adjust a cell in increments
of 0.1 but excel will not let me set the change value to anything less
than 1. Is there any way around this? Any advice/help would be greatly
appreciated.Thank you.


Dave Peterson

Scrollbar help
 
How about using two cells.

If the linked cell is A1, then use a formula like:
=a1/10
in B1 (say)

wrote:

I am trying to have a scrollbar that will adjust a cell in increments
of 0.1 but excel will not let me set the change value to anything less
than 1. Is there any way around this? Any advice/help would be greatly
appreciated.Thank you.


--

Dave Peterson


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

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