changing image when mousepointer moves over certain cells
 

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

changing image when mousepointer moves over certain cells
 

If you mean to load and display the userform on cell mouse move; then try
placing a image control from Control ToolBox.
--Right clickFormatControlProperties and check 'Move and size with cells
--Right clickPropertiesBorderStylle to 0-fmBorderStyleNone
--Right clickPropertiesBackcolor 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
---------------
Jacob Skaria


"lieven" wrote:

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

changing image when mousepointer moves over certain cells
 

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
"lieven" wrote:

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