Prompt User to Select a File Path on Cell Selection in Excel
I have a worksheet that downloads a bunch of files to a location specified
by a user in a cell . What I'd like to do is add validation to this cell
such that when it is clicked, the file selection window opens, and the
user is able to specify the desired location. Is this even possible? I
know it can be done through a button triggered macro, but I'd really like
it to work more like other types of validation, such as a drop down menu.
Any pointing in the right direction would be much appreciated...non
computer types have more trouble typing in error free paths than you could
possibly believe.
No comments:
Post a Comment