Userform Scrollbar Event

I got a little problem with searching for the correct event or the result of it.

I want to have an event that will activate a script when the value of a scrollbar changes. (not other property changes)

I know i need this event:

Please Login or Register  to view this content.

but how do i make it so that it only triggers the script when the value of the scroll bar is changed

(scrollbar is scrolled down or up to change value)
Tnxs in advance

I don't follow you - the change event will only fire when the scrollbar value changes.

As RS says the change event will only fire when the scroll value changes.

Changes are triggered by clicking either End Arrow or within the scrollbar (large change).

Dragging the scroll button, located within the scroller, will trigger the Scroll event and upon release of the button the change event will fire.

For me the event only fires if the min is greater than value, which on initialize is zero.

EnableEvents will not affect the userform. You will need to use a variable, local to the userform, so you know when to remain in the change event.

Please Login or Register  to view this content.

That should only trigger a change event if altering the min and/or max requires a change in value - e.g. you set the min to 1, but the value is 0 at design time (so when you set the min, the value has to change to 1).
Enableevents does not affect controls - you need to use a boolean flag variable declared at the top of the module.

It (almsot) works now.

i just got 1 issue

Please Login or Register  to view this content.

Could you explain what this does?
Also i recieve an error from it from the macro that is placed above this line.

Please Login or Register  to view this content.

#Edit

you need to use a boolean flag variable declared at the top of the module

Sorry answer was given.

Solved Tnxs alot