I've got a "configuration" workbook that stores the filename of an arbitrary "data" workbook and the cell address of a particular piece of data in that file.
I'd like to design a helper macro for filling out the "configuration" workbook. I'd like to be able to display the contents of the "data" workbook in a userform and prompt the user to select a cell. The address of that selected cell would then be automatically stored in the "configuration" workbook.
Can anyone recommend a strategy? Is this plan even possible?
Bookmarks