changing image when mousepointer moves over certain cells

  • Thread starter Thread starter lieven
  • Start date Start date
L

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
 
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
 
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
 
Back
Top