Browse Folder Dialog - show msgbox if nothing selected

[VBA FTW]

I'm having some trouble showing a messagebox if the user presses OK but doesn't select a folder using msoFileDialogFolderPicker. Can someone help point me in the right direction?

Please Login or Register  to view this content.

The 2 MsgBox's I've added show the same string, yet the If Not InStr line returns true regardless if ":\" is in the string or not. Any advice or other methods you can suggest?

[mc84excel]

I use a reusable function as a folder picker. You can use len on the result to see if a folder was returned or not. See below:

Please Login or Register  to view this content.

[Norie]

Perhaps.

Please Login or Register  to view this content.