Hi All,

I am new to this forum and I have minimal knowledge on VBA/Macro. I had recorded a macro which requires 3 different input files to get the output. I also designed a userform with userframes that contains text box and command button in order to browse the input files.

I am not able to write the program for browsing the path of the input files and also to link the macro with the userform. Once when the user clicks the command button on the userform, the path of the input file location should appear in the text box. As there are many userframes in a single userform, kindly help me with program how to link those userframes.

Since the macro has been recorded, all the process to get the output is seen by the users. I want a blank screen on the desktop of the users and to run the macro at the back end.

Apologize if i am not clear with the request.

Thanks in Advance.