Code to Create Input Box To Select a File

[Jeremy]

I am looking to crate an input box that will allow the user to select a file.
This will be like the browes option. The file selected will not need to be
opened, just have the full path entered in the cell. This will be used to
formualte a VLOOKUP form the selected closed file.

 

[Rick Rothstein \(MVP - VB\)]

You could use code similar to this...

Dim FileName As String
FileName = Application.GetOpenFilename
Range("A1").Value = FileName

but you should look up the GetOpenFilename method in the help files as there
are some optional arguments available that will let you customize things a
little bit.

Rick