Offset with scrollbar

[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

 

[T. Valko]

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.

 

[H.G. Lamy]

Perfect !

Many many thanks !

Regards,

hgl

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.

 

[T. Valko]

You're welcome. Thanks for the feedback!