View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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