MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How can I grab the values of the scroll bar in a bunch of scrollbar

  Asked By: Nicole    Date: Aug 10    Category: MS Office    Views: 468

I have a form where there are a number of scrollbars, each named
sbaScrollBarx; where x is an integer value between 3 and 20.

I want to grab the scrollbar value for each of these controls and
assign it to an element in an array.

I will then rank these values of the scrollbars and re-position these
scrollbars based on their rank. I'm pretty sure I can do a simple for
next loop for this step, but right now, I don't know how to get the
values themselves.

Any clues?



2 Answers Found

Answer #1    Answered By: Edna West     Answered On: Aug 10

Dim sbvals(3 To 4)
For i = 3 To 4
sbvals(i) = UserForm1.Controls("sbaScrollBar" & i).Value
Next i

Answer #2    Answered By: Guilherme Silva     Answered On: Aug 10

As with the .Value property?

Where is this giving you trouble?