John asks if there is a way to automate the process from Episode 322 of adding pop-up pictures to a cell. Today's Episode 1108 takes a look at the VBA code to add pop-up pictures to many cells.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Thank-you Thank-you Thank-you Thank-you Thank-you Thank-you Thank-you!
I've never really done anything in VB before or used the editor. But amazingly Ive got this working in a matter of minutes. At first it couldn't find the images, so I asked it to put the file name in the comments box instead of the image. I could then see that I have missed of a backslash. ran again and hey presto it works. I've been pondering for years how to achieve this.
absolutely brilliant !
davewilson1969 19 hours ago
I run into the same error. Does anyone know how to fix this? I am using Excel 2003.
muraisiz 10 months ago
Off late I started watching Mr Excel video's. Amazing!!!!!
However, when I run this macros, it was saying - Run time error '1004' Application defined or Object defined error and stopping at " with cell.addcomment (highlighting with yellow color). I guess my VB settings are wrong. Can you please help me out.
Mohan
gopalk135 1 year ago
Awesome!!! Thanks for the eBook
marinermarc 1 year ago