Offset with scrollbar

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
 
T

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

H.G. Lamy

Perfect !

Many many thanks !

Regards,

hgl

T. Valko said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top