Tim,
Here's one way:
http://vbnet.mvps.org/code/browse/browsefolders.htm

I believe XL2003 and up have a built in dialog to do the same.

NickHK

"TimB" <u32108@uwe wrote in message news:6e74b2f7ac03c@uwe...
I am having trouble finding help on what i am looking to do, so i am
hopeing
someone here can help me. I have a user form that has a text box and a
button in it. When the button is clicked i want a file directory to show
up
so that the user can select a location, particular folder, and click ok.
This location will then be put into the textbox. The reason is that there
are a few other text boxes where the file name is entered and then another
button that will save as that name in the chosen location. Thanks in
advance
for any help.