Forum Discussion
Show image from url while hovering mouse
- Jul 20, 2021
DavidAz81 I believe I had the same issue using the code found at https://stackoverflow.com/questions/43923102/hover-preview-over-excel-image-link . I had the same problem until a saw a comment when they explained the updated reference. The solution is simple. first use the hyperlink function in your language, but more than this, you need to correct the cell code. in the original post it was "=HYPERLINK(OnMouseOver("http://i.imgur.com/rQ5G8sZ.jpg"),"http://i.imgur.com/rQ5G8sZ.jpg")" but it should be changed to =HYPERLINK(OnMouseOver("http://i.imgur.com/rQ5G8sZ.jpg";A1); "http://i.imgur.com/rQ5G8sZ.jpg")
Any way, i did use it like this. On A column i have the list of hyperlinks (in text such as https://sitename.com/filename.jpg) (A2 is the first image), on B column I use this formula (on B2) I have =HYPERLINK(OnMouseOver(A2;B2);A2) on C column the =HYPERLINK(Reset()) .
in this sample I used the same image link on all cells (lazy me) but it works. . anyway, it is not the best solution yet. I am working on other easier way. this is a screenshot of the sample.
Hope it helps someone.. . the real advantage in this one is that you do not save all pictures in the excel file, as you say, if your list is large it would not be practical, but I think there must be a better way. i have included the sample file, but in case you don't want to download a unknown file, just follow the instructions.
NikolinoDE Thanks for your reply. Of course I'm willing to accept any suggestions.
I already saw that option (to add a picture in the comments) and it could work but I didn't find the way to do it automatically nor with images that are stored online (not on my hard drive). If you know how please let me know.
Regarding the second option, that is exactly what I'm trying to accomplish. I checked that yesterday and tried to run it but I kept getting errors. Again, I'm new to this and I must be doing something wrong.
To start with my Office is not in english and I can't get a way to start with this text:
=HYPERLINK(OnMouseOver("http://i.imgur.com/rQ5G8sZ.jpg"),"http://i.imgur.com/rQ5G8sZ.jpg")
and I always get a #NAME? error.
I think it's because of the OnMouseOver function that I cannot translate to spanish.
Do you happen to have a xlsm file with that macro applied?
Thanks again.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)