Display selected file path(command button) in textbox

hello there,

i am in abit of a struggle now. i am just wondering how is it possible to display a sected file path in a textbox.


ok let me describe to u how my macro is.

i have a command button that once clicked, an explorer window(just like how someone opens a file in word) will appear for the user to select the file to open. upon the user selecting the file, i want the path of that file to appear in the textbox next to the button. this is done first because i have another button at the botom of the macro to open the selected files upon clicking.


how is this done in the macro. what is the coding required for this.


please help.


regards

sam