Nov 10 2020 03:38 PM
Hello.
I've been trying to do this for days and it's driving me crazy.
I have an Excel file with thousands of URL of images on column A such as:
www.mywebsite.com/images/001.png
www.mywebsite.com/images/002.png
www.mywebsite.com/images/003.png
and I would like it that the thumbnail from the correspondent image is shown while I hover the mouse over the link (or even while hovering an adjacent cell).
I understand this needs some VBA (which is all new to me).
I've tried to run some macros but they simply add pictures to the Excel file itself and I want to keep the file as light as possible.
The file has thousands of references and I don't know them by heart. I managed to have the link to the product page but a simple thumbnail of the item's photo would do the trick, instead of having to open a webpage in the browser everytime I want to confirm that the item is correct.
Thanks in advance for your help.
Cheers!!
Nov 11 2020 09:00 AM
With your permission, if I may add a thought to your project, instead of using the hyperlink, insert a comment.
Here is the installation description:
Cursor in cell with comment
> right mouse button
> edit comment
> right mouse button click on the edge of the comment field (not very easy)
> select format comment
> colors and lines
> drop down color
> fill effects
> tab graphic
> select graphic
Is just a thought
Or here a VBA approach:
Hover preview over excel image link
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Nov 11 2020 01:55 PM
@Nikolino 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.
Nov 12 2020 12:14 PM
* 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)