Control Toolbox

[ldb]

I'm using the scroll bar from the Control Toolbox. The reason why I'm using it is because I can not rotate the scroll bar from Forms.

Anyway, how do I add incremental values? I currently defaults to one. I'm using Excel 2002.

 

[Damon Ostrander]

Hi Idb,

1) Forms scrollbars cannot be "rotated", but can be drawn either vertically (vertical scrolling) or horizontally (horizontal scrolling). The scrollbar will switch from vertical to horizontal (or vice-versa) when you size it to be longer than it is high.

2) You can effectively change the default increment by simply multiplying the value. Of course the Value varies from 0 to 32767 in steps of 1. But for example if you want it to go from 0 to 100 in steps of 1 simply divide the Value by 327 using integer divide ("" instead of "/").

 

[Damon Ostrander]

Hi Idb,

1) Forms scrollbars cannot be "rotated", but can be drawn either vertically (vertical scrolling) or horizontally (horizontal scrolling). The scrollbar will switch from vertical to horizontal (or vice-versa) when you size it to be longer than it is high.

2) You can effectively change the default increment by simply multiplying the value. Of course the Value varies from 0 to 32767 in steps of 1. But for example if you want it to go from 0 to 100 in steps of 1 simply divide the Value by 327 using integer divide ("" instead of "/").

PS. I'm submitting it a second time because I forgot to disable HTML the first time.

 

[Damon Ostrander]

Well, that didn't solve the problem either. I was just trying to get the backslash character to show up between the first set of double quotes in my first message.