If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Offset with scrollbar
Hello,
I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length / address of the month's list (named range) must adapt to the remaining # of months. For example: if I pick March (= index 3 of the scrollbar's cell-link, the month's list should have left 9 rows (April - December). If I choose scroll to October, the list (named range) should only have 2 rows left (November - December), etc. Any idea how to do it, possibly with Offset(....) ? Thank you in advance. Kind regards, hgl |
#2
|
|||
|
|||
Offset with scrollbar
I would need to see the file to try and figure out what you're wanting to
do. If you can post a small sample file at a free file host I'll take a look. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Hello, I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length / address of the month's list (named range) must adapt to the remaining # of months. For example: if I pick March (= index 3 of the scrollbar's cell-link, the month's list should have left 9 rows (April - December). If I choose scroll to October, the list (named range) should only have 2 rows left (November - December), etc. Any idea how to do it, possibly with Offset(....) ? Thank you in advance. Kind regards, hgl |
#3
|
|||
|
|||
Offset with scrollbar
Thank you for feedback!
Please find my sample attached here. When scrolling the months the list should always end with December. Can "Offset(...)" or another function be applied so intelligently that this is achieved ? Kind regards, hgl "T. Valko" wrote in message ... I would need to see the file to try and figure out what you're wanting to do. If you can post a small sample file at a free file host I'll take a look. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Hello, I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length / address of the month's list (named range) must adapt to the remaining # of months. For example: if I pick March (= index 3 of the scrollbar's cell-link, the month's list should have left 9 rows (April - December). If I choose scroll to October, the list (named range) should only have 2 rows left (November - December), etc. Any idea how to do it, possibly with Offset(....) ? Thank you in advance. Kind regards, hgl |
#4
|
|||
|
|||
Offset with scrollbar
Ok, here you go.
I've assumed that when the spinner linked cell = 12 (for December) then the list is "empty" since there are no months after December. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Thank you for feedback! Please find my sample attached here. When scrolling the months the list should always end with December. Can "Offset(...)" or another function be applied so intelligently that this is achieved ? Kind regards, hgl "T. Valko" wrote in message ... I would need to see the file to try and figure out what you're wanting to do. If you can post a small sample file at a free file host I'll take a look. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Hello, I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length / address of the month's list (named range) must adapt to the remaining # of months. For example: if I pick March (= index 3 of the scrollbar's cell-link, the month's list should have left 9 rows (April - December). If I choose scroll to October, the list (named range) should only have 2 rows left (November - December), etc. Any idea how to do it, possibly with Offset(....) ? Thank you in advance. Kind regards, hgl |
#5
|
|||
|
|||
Offset with scrollbar
Perfect !
Many many thanks ! Regards, hgl "T. Valko" wrote in message ... Ok, here you go. I've assumed that when the spinner linked cell = 12 (for December) then the list is "empty" since there are no months after December. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Thank you for feedback! Please find my sample attached here. When scrolling the months the list should always end with December. Can "Offset(...)" or another function be applied so intelligently that this is achieved ? Kind regards, hgl "T. Valko" wrote in message ... I would need to see the file to try and figure out what you're wanting to do. If you can post a small sample file at a free file host I'll take a look. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Hello, I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length / address of the month's list (named range) must adapt to the remaining # of months. For example: if I pick March (= index 3 of the scrollbar's cell-link, the month's list should have left 9 rows (April - December). If I choose scroll to October, the list (named range) should only have 2 rows left (November - December), etc. Any idea how to do it, possibly with Offset(....) ? Thank you in advance. Kind regards, hgl |
#6
|
|||
|
|||
Offset with scrollbar
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Perfect ! Many many thanks ! Regards, hgl "T. Valko" wrote in message ... Ok, here you go. I've assumed that when the spinner linked cell = 12 (for December) then the list is "empty" since there are no months after December. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Thank you for feedback! Please find my sample attached here. When scrolling the months the list should always end with December. Can "Offset(...)" or another function be applied so intelligently that this is achieved ? Kind regards, hgl "T. Valko" wrote in message ... I would need to see the file to try and figure out what you're wanting to do. If you can post a small sample file at a free file host I'll take a look. -- Biff Microsoft Excel MVP "H.G. Lamy" wrote in message ... Hello, I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length / address of the month's list (named range) must adapt to the remaining # of months. For example: if I pick March (= index 3 of the scrollbar's cell-link, the month's list should have left 9 rows (April - December). If I choose scroll to October, the list (named range) should only have 2 rows left (November - December), etc. Any idea how to do it, possibly with Offset(....) ? Thank you in advance. Kind regards, hgl |
Thread Tools | |
Display Modes | |
|
|