Mouseover image

[IGORRR]

Hi;

I have a table with one column with the path of some images (B)

I would like when I put the mouse over one cell of a column (A), that show the image of the path of the column B, but when I move the mouse from the cell close the image.

Thanks in advance.

[Andy Pope]

One way would be to define your own slicer style and apply that

The OM does not appear to expose formatting properties directly

[IGORRR]

I prefer with Visual:

I have one example but it only works for one excell.I would like to modify it to use for one complete column. If I put the mouse in A1 open the image of the path that it is in B1, the same for A2 and B2,.....

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = "$C$1" Then
ActiveSheet.Pictures.Insert("C:\Documents and Settings\Administrator\My Documents\My Pictures\Sample.jpg").Select
End If
End Sub

Could you help me?

Thanks in advance

[Andy Pope]

@IGORRR, my post should have gone to another thread about formatting slicers. Either the forum or me made a mistake.

There is no mouse over event on the worksheet.

Maybe you could use the comment to hold a picture, obvously loading all the pictures will bloat the workbook.
http://www.contextures.com/xlcomments02.html#Picture

[IGORRR]

Hi Andy:

Is it possible covert that code in an mouseover and working through paths in columns?

I prefer not to use the solution inserting comment.

Thanks in advance.