View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PSchmidt PSchmidt is offline
external usenet poster
 
Posts: 10
Default User form with sliding separator on a list - how to do it?


I'm trying to figure out how to do this in a user form and have no idea how
to do so/manipulate the output, so looking for suggestions.

I want to put out a list of 10 numbers, with some sort of separator as one
of the 'rows'. Then have a spinbutton which will move the separator up or
down a single row. The 'amateur' way would be to have a large label where I
put in 11 rows - 10 numbers with a '---------' as one of the rows. Then
redraw it everytime one of the spin buttons is pushed, moving the '--------'
row. But this is looks ugly.

I'm looking for suggestions on how to display the data on a user form in a
much nicer format - some way I can display 10 rows of numbers w/ some form of
separator which will move up or down. I could work something out w/ variable
size label boxes and some separator graphic line on a user form, but don't
know how to do this either.

Thanks,

Perry

P.S. For those who are curious, this is for a calculation which is being
done on each group of an ordered list of numbers - a calculated value will be
displayed for each group, and when the separator is moved/scrolled up or
down, the values for the top/bottom group will be recalculated. AFter the
user finds where they want the separator, based on the results of the
calculated values, they will hit an 'OK' button which will transfer all the
data to a spread sheet. I don't want to do this on a spread sheet because
there's no good area to do so, and I don't want to do so on a separate spread
sheet. Otherwise I could use the spin buttons to 'redraw' boarder styles on
a list. I'd really prefer to do this in a user form. I don't have
objections to using a list box or something similar, but again not sure how
to present the separator in this.

Thanks again.