David Phelops
asked on
Double-Click ListBox entry - assign result to a variable
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
ShowOpenWorkbooks.xlsm
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
ShowOpenWorkbooks.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers