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

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

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

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

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

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