Hi all,
I am currently have an idea that requires the use of macros (especially userform)
The overview of how the macro will run is as the following:
1. A Userform box will apepar upon running the macro (see attachment 1)
2. The user will then be able to browse out the relevant files that he/she wants to compile. We are talking about multiple files to be opened and then extracting & pooling together relevant data from each of these multiple files
3. I want the Userform to display as well the specific path-name of the files being "browsed out". This should be sort of a list box being displayed in the empty space as shown in attachment 1.
4. Upon "browsing out" all the requried file, the user will then click on the 'Compile' button and then the relevant data from each files will be compiled together.
Currently, I figured out how the browse macro code should be. They are listed below
However, I am stuck in figuring out the macros code to generate the list box that will display the relevant files being browsed.
Will appreciate fi anybody can help
Thanks!
Bookmarks