In the attached file the user-form (uf_OpenWorkbooks) lists the open excel workbooks.
It instructs the user to double-click the required workbook, or cancel if the workbook is not open.
What code do I need to use to assign the double-clicked entry to the variable that will be used in the next part of the macro, I.e. activate the chosen workbook?
So far I have succeeded to activate the chosen workbook by clicking OK.
Thanks very much