I want to popup images using mouseover NOT via the "comment" route

[hupo72]

Using the "comment" to popup images on mouseover is a great way.
Yet over a certain number of comments the files gets real "heavy" as it probably contains the images too.
I need a mouseover image popup system that takes into account some 100,000 or more images.
I was told that VBA does the trick. Anyone know how that would work?

Thank you

 

[Jaafar Tribak]

Hi and welcome to the board.

There is no mouseover event for worksheets ... You could use a background timer to continiously track the mouse location and act accordingly based on the current range under the mouse pointer but that would put a strain on the system

RickXl posted in this forum a a neat trick that uses Hyperlinks to run macros when pointing to the cell that has the hyperlink in it ... It is ,IMO, a better approach than using a loop or a timer

Take a look at this thread

 

[hupo72]

Thanks Jaafar,
Looks like it might do the trick although I'll have to dig in a bit to understand it
Looks good. Thanks again