ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   scroll bar incremental change size (https://www.excelbanter.com/excel-programming/297215-scroll-bar-incremental-change-size.html)

Liam[_2_]

scroll bar incremental change size
 
I've got a scroll bar (Forms toolbar control) and I want
to specify the following properties:

min value = 0
max value = 1
incremental change = 0.01
page change = 0.2

After I type these values into the "Format Control"
dialog box, Excel seems to replace both incremental and
page change values to 0. It appears that Excel wants
integers. Is this true, and if so, how do I work around
this limitation?

Juan Pablo González

scroll bar incremental change size
 
Multiply your values by 100

Min = 0
Max = 100
Inc: 1
Page: 20

--
Regards

Juan Pablo González

"Liam" wrote in message
...
I've got a scroll bar (Forms toolbar control) and I want
to specify the following properties:

min value = 0
max value = 1
incremental change = 0.01
page change = 0.2

After I type these values into the "Format Control"
dialog box, Excel seems to replace both incremental and
page change values to 0. It appears that Excel wants
integers. Is this true, and if so, how do I work around
this limitation?





All times are GMT +1. The time now is 08:57 AM.

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