Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Thousands separator in form and live calculations in form. | Excel Discussion (Misc queries) | |||
can I calculate S&H on a sliding scale in an order form? | Excel Worksheet Functions | |||
User Form List Box | Excel Programming | |||
User Form / List Box | Excel Programming | |||
Creating a list box in a user form | Excel Programming |