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
|