Select workbook (or workbook/worksheet) (Frm5)

Gives your user ability to select a workbook from list of open workbooks within same session.
Or call "SelectWorkbookWorksheet_ANmar" to give users option to select workbook/worksheet from list of open workbooks.
See examples


Public

Tested

My Own Work
If user presses cancel, blank string is returned, in both functions

Call "SelectWorkbook_ANmar" function to show form asking users for a workbook, then return the selected workbook if selected, or null string if cancel.

Call "SelectWorkbookWorksheet_ANmar" function to show form asking users for a workbook/worksheet combination, then return the selected workbook name and worksheet name separated by {{$S$}}.

None

Msgbox SelectWorkbookWorksheet_ANmar()

Msgbox SelectWorkbook_ANmar()

Views 1301 Downloads 582

VBA-Excel Sessions
ANmarAmdeen
642
Attachments
Revisions

v1.0