| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scrollbar Help | Charts and Charting in Excel | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Scrollbar help | Excel Discussion (Misc queries) | |||
| Chart / Scrollbar / Offset / Autofilter | Charts and Charting in Excel | |||
| scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Linear Mode
