Active X Scroll Bar properties

[Miles R]

Any one know how to set the Min and Max values of an Active X Scroll bar from VBA?


I know I can set them in design mode, but in VBA there does not seem to be a Min or Max property in the Intelisense drop down list.
Maybe it is hidden under another property.

[Miles R]

Further to this enquiry, I set the max value using vsbScrollBar.Max from VBA and it seemed to work. Maybe intelisense does not show properties from Active X controls.

However, next problem is I am trying to move items on my form when the scroll bar is moved, but none of the available events are any good. These are :-
On Updated, On Enter, On Exit, On Got Focus, On Lost Focus. I was expecting On Updated to trigger when I move the slider, but it is only triggered when I move to another control - since the only other control on the form is Exit Form, this is no good.