With the (userform) scroll bar selected, press F4. This displays the Properties Window. You can change the "Max" property for the top limit to go. I set it to 100000 no problem. As for percentages, not sure how you want it formatted but I just put a label on the form to reflect the updating scrollbar value with a percentage sign behind it. ?
Private Sub ScrollBar1_Scroll()
' Label is renamed as "lblValue"
lblValue.Caption = ScrollBar1.Value & "%"
End Sub
Quote:
|
Originally Posted by JEFF
Hello All,
I'm a first time user of a form. I'd like to use the Scroll Bar, but two
problems:
1. It only allows whole numbers (I'd like to use %)
2. Max value is 30,000 (I'd like it to be higher)
Any thoughts?
TIA
|