MouseOver cell that makes apear and disappear an image

[first_mo_za]

Hello,
Please Help

I would like to do a routine in VBA on excel 2007 that makes the following:
1- When the mouse is over a cell it pops-up a window that shows a picture;
2- When the pointer is removed from the cell the window that contains the picture closes;
It is very important that the picture that is shown be adressed by a relative path from the folder in which is the excel file.
The pictures can change; this is the reason that the picture should be addressed by a path.

Thanks a lot

[davesexcel]

Is the path address in the cell?

[first_mo_za]

Dave,

The "address" is the same folder in which the excel is.
Thkx

[davesexcel]

This code will find the .jpg in the active workbook folder and place the address into cell G1.
It will then add a comment into A1 and use the address in G1 as the source.

Please Login or Register  to view this content.

[teylyn]

Just quoting here, but a similar topic came up yesterday in another thread

There are no mouse movement events for a workbook.

Activex controls on the worksheet have mouse events as do controls on a userform.

Edit: Scratch that then, comments are obviously the exeption. Nice!

[first_mo_za]

Dave,

Sorry. It gives me an error "run-time error 445" at the linecode "With Application.FileSearch"

Thkx

EDIT: Thkx Dave. I've solved the issue. I realized that Application.Filesearch is no longer available in excel 2007. I got it to work with this from Roy's blog http://excel2007tips.blogspot.com/20...h-in-2007.html

Thank you

[davesexcel]

I did not know that, I had just assumed that XL'07 could run XL'03 VBA, thanks for the link.

Could you supply the code so people with XL'07 can use it.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[blakito]

Hi mates, sorry for ressurection this topic but i need the same solution.

I couldnt get it to work in Excel 2012 with the code provided, and couldnt adapt it myself using first_mo_za tip.

Anyone can help me ?

[arlu1201]

Blakito,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.