Populate a Dropdown with names of open workbooks, when slected store as variable

I am trying to create a dropdown that is polulated with the names of the open workbooks. When the user selects the workbook from the dropdown list I want to store that as a variable.

So far I have a dropdown that populates the open workbooks however it does not seperate them correctly. It displays in one row.


I also don't have the piece that will store that as a variable to be used later.

Please Login or Register  to view this content.

I couldn't get that to work.

Thank you for you response rwgrietveld.
I have created the serform and it populates as it should. I have also created a button to close the form.

What I am trying to do is take the selection from the dropdown on the userform and use it as a variable for macros which I have in Module1. Right now the variable is empty in the module
Form:

Please Login or Register  to view this content.

Module1:

Please Login or Register  to view this content.