Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm
(look for BrowseForFolder)

John Walkenbach has one at:
http://j-walk.com/ss/excel/tips/tip29.htm

If you and all your users are running xl2002+, take a look at VBA's help for:
application.filedialog(msoFileDialogFolderPicker)

Greshter wrote:

Hi All

I am trying to create a form which has a button which can browse for a
folder path. I then need to have this path placed in an adjacent
textbox. I think I need something along the lines of the following in
the command button's code:

Application.GetOpenFilename

however this piece of code just opens a file whereas I need the
pathname for a folder.

Any ideas out there would be greatly appreciated.

Cheers,
Mike

--

Dave Peterson