How To Print from Multi-Select Listbox Using Named Ranges

[ScotyB]

Hi all,

in the attached dummy file is a userform listbox (multi-select) that displays months of the year for 2019 and 2020 (set using the rowsource property). What I'm trying to achieve is a printout from those multiple selections using named ranges on a specific sheet (Roster).

I think the problem is with syntax in the userform initialise section _ I don't know whether to use listindex, listcount, listitem or listselected to specify what named ranges the listbox items should refer to - they all seem to throw up a type mismatch error.

Could someone point me in the right direction?

Cheers,
AJ

[Norie]

You can't populate a listbox using RowSource and List.

Which named ranges do you want to associate with the dates in the RosterRange?

[ScotyB]

Norie,

I'd like first item in the listbox to be associated with named range "Alpha" on the Roster sheet, the 2nd item to be associated with named range "Bravo", and so on...

Cheers,
AJ

[ScotyB]

One upwards bump before I let this one go...

[bakerman2]

How about this one.

Please Login or Register  to view this content.

[ScotyB]

Thanks, bakerman2,

that worked a treat on the dummy test file - I'll try it on my actual work file when I'm back at work in a few days and let you know.

Thanks for taking a look.

Cheers,

AJ

[ScotyB]

bakerman2,

tested this on a work file today and no problems so far - thanks for your help.

AJ

[bakerman2]

Thanks for feedback and rep+.