changing image when mousepointer moves over certain cells

[lieven]

Hi,

I would like to change the image in a userform when the mousepointers moves
over a certain cell.
I know how to make it work when the cell is selected but not when only the
mousepointer is above the cell.
Can anyone help me?

Thanks,

Lieven

 

[Jacob Skaria]

If you mean to load and display the userform on cell mouse move; then try
placing a image control from Control ToolBox.
--Right click>FormatControl>Properties and check 'Move and size with cells
--Right click>Properties>BorderStylle to 0-fmBorderStyleNone
--Right click>Properties>Backcolor to match cell back color
Double click the control and use the mousemove event

Private Sub Image1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
'your code to load userform,chnage image,show form
End Sub


If this post helps click Yes

 

[Howard31]

Put a object from the ActiveX controls toolbar, like a lable on that cell
double click that label which will bring up the code mudule for that label
and put your code in the 'MouseMove' event handler.

Hope this helps.

A. Ch. Eirinberg