Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change font size on screen, but prints in old size lvrcdval Excel Discussion (Misc queries) 2 July 19th 07 02:36 PM
How to make spinbox in 0.1 incremental change? GOTPAPA Excel Discussion (Misc queries) 1 August 18th 06 01:37 PM
how do I change the size of vertical scroll bar Peg B Excel Discussion (Misc queries) 6 July 29th 06 02:48 PM
How do I make the verticle scroll bar full size post row delete? jaws2act Excel Discussion (Misc queries) 1 February 15th 06 09:35 PM
Spinner Button - Incremental Change Anauna Excel Discussion (Misc queries) 1 July 6th 05 07:17 PM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"