Frm9 - Select workbook (or workbook/worksheet)

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

CodeFunctionName
What is this?

Public

Tested

Original 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 2,612

Downloads 962

CodeID
DB ID