Greetings,

I tried the following:

Private Sub ScrollBar1_Change()
ScrollBar1.Value = 5
End Sub

i.e I wanted to see if I could set the scrollbar value within the _change event and it worked fine but when I used bookmarks, I found that the event was called repeatedly and then terminated. What is the way to set the value property without trigerring the change event again inside the change() method?

I also tried using a module level variable and did this but it still executes twice?
Private Sub ScrollBar1_Change()
If (gbEvents) Then
gbEvents = False
ScrollBar1.Value = 5
gbEvents = True
End If
End Sub

Is there any solution to this? If the user sets a very low value, I want to reset it to what it was before the change event. That is why I require such a method.

Please help. Will be glad to clarify any issues.

REgards,
Ram