With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
If you can only select 1 file it's always the last modified & the first modified.

Your question is a 'contradictio in terrminis'