Hi Tom,
You might want to mention that after selecting a sheetname from the list "as
listed", Excel will treat it as an actual date. If the user doesn't want that
but wants it to appear exactly "as listed", the cell(s) using this DV should
be formatted as TEXT.
Regards,
Garry
Bookmarks