Hey everybody,
I am new to VBA code and looking for some help on utilising user input from a pop-up box as the starting position for the rest of a macro.
I have the found the below code elsewhere that will satisfy the requirments selecting the starting cell for the rest of the code, but am unsure how to pass this onto the next part of the code:
Here's the problem in a nut shell:
I have 4 or 5 files whose data I want to extract into a Master or Summary workbook. The data begins at the same cell location within these files but they are of varying lengths. So the problem is, I can key the starting point within that file, but not the end point and therefore cannot assume where the next files data should begin executing the various if-statements within the Master spreadsheet.
So I would like the user to ideally specify the name and location of the first file and where the ensuing code should start running from within the Master sheet. Ans then repeat this process for all the data files.
So ideally there would be a pop-up box that asks:
How many files do you have?
Where/What is the name of the first file?
What cell should we start executing code in?
Where is the seond file?
What cell should we start executing code in?............and repeat for all files.
I hope this is specific enough, let me know if you need more detail or clarification.
Cheers,
Kane
Bookmarks