I want to create a file browser dialog box to allow the user to select a folder rather than a file (i.e., use the dialog box to generate a path). I know this is possible, and I suspect it's a standard option for Windows dialog boxes because I've seen it done fairly often in other applications. The only question is: is there an option for this in VBA?
I know I can easily create a "File Open" dialog box with the following code:
Code:
Application.Dialogs(xlDialogFindFile).Show
But this dialog only allows the user to select a file. Is there an option to modify this (or a totally different kind of dialog box) to select and return a path with no filename?
I'm running Office XP 2002.