Copy MultiSelections from a MultiColumn List Box to a Sheet range

[GPSPOW]

I have a table created by a MS-Query. The MS-Query is tied to a master SQL table. The MS-Query table is created dynamically based on a data range input by the worksheet user.

The master table in SQL are all my physicians and their admission dates. The MS-Query creates a subset of the physicians who have had patients admitted based on the date parameters input by the user.

I have a 2 column list box (lstSelector), columns Name and ID, tied to the named Table range (Providers).

I want the user to be able to select multiple items from list box and paste them to a blank sheet called "DATA" in the workbook.

The selected items will be used in a print command to only output a report for those physicians selected.

I have been tinkering with many solutions but I have yet to find one that works.

Can someone please help?

Thank you

Glen

[stnkynts]

Can you submit a copy of your workbook with all sensitive information replaced with non sensitive information.

[GPSPOW]

Here is the workbook.

The name of the list box is named lstSelector
The tab with the MS-Query is Provider Table. the named range is columns A:B
The userform with the command button, Add Physician, is frmSelector.

There is an attempt to code the On click command for the Add Physician button.

Thanks

Glen

[stnkynts]

You were really close with what you had:

Please Login or Register  to view this content.

[GPSPOW]

Thank you

That worked perfectly

Glen