List Box + Sharepoint Navigation
 

lI have a master index spreadsheet with links to folders containing
sharepoint folder names. For simplicity sake lets say that there are 2
columns in this spreadsheet. Column A has a description and Column B the
sharepoint url.

I would like to have a macro to:
1) create a list or combo box containing the values in Column A and allow
the users to choose an item from the list
2) Open the corresponding Sharepoint folder so the user can select a file to
open.
3) Kick off another macro that does some stuff that I already have completed.

Your help is greatly appreciated.

Thank you