Print from Listbox

Hello there,

Currently I have a listbox in a userform containing the names of all the worksheets in my workbook. What I would like (if it is possible) is for the user to be able to click a button below this listbox which will print the worksheet currently selected in the listbox. Does anyone know how I would go about doing this?

Many thanks,

Tom

Something like:

Please Login or Register  to view this content.

should do it (adjust control name to suit!).