Hi all
I'm very green when it comes to VBA/Macros in excel, but I'm building a template that will be used by multiple teams to track their data collection.
I want to build in some functionality so that if they select "yes" from a data validation list in a cell, they will be prompted to attach a file. I've got this working for a single cell, but I want to replicate this across a bunch of cells in different rows and columns. Hope that makes sense.
The macro I put together from reading around the internet, is:
Combined with the following code I inserted in the workbook (by rightclicking on the sheet, going to View Code), I can get this to work, for the one cell "M3".Please Login or Register to view this content.
How can I apply this to multiple cells in multiple rows and columns? I can't get it to work without completing messing up.Please Login or Register to view this content.
Many thanks in advance!!
Bookmarks