Link to home
Start Free TrialLog in
Avatar of David Phelops
David PhelopsFlag for United Kingdom of Great Britain and Northern Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of KyleSW
KyleSW

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of David Phelops

ASKER

Thanks - another link in the chain!

Cheers