I am writing an excel macro that requires a user to input the path of a
file. I have code to ensure that the file actually exits but would
prefer to have a buttont that pops up a windows that allows the user to
BROWSE up to the file and when he follows the path and eventually
double clickson the file it stores that path instead of him having to
type it into a cell/input box somewhere.

Can anyone help with this?