H
H.G. Lamy
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
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