I have developed a macro that does a whole bunch of things for me based on a few things. (Importing files).
The file names are dated
dd_mm_yyyy and right now I enter them into a sheet where the macro can retrieve the information. Not really wanting this I designed a userform where the user can enter the "dd", "mm", "yyyy" and how many consecutive days of files there are.
there would be one consecutive day.
I want to be able to retrieve the information entered in the userform (day, month, year, and consecutive days) to use in the macro and have been unsuccessful because I don't know how to access that information. Is it similar to referring to a range in a worksheet?