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