Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TIFF image moves for no reason when printed | Excel Discussion (Misc queries) | |||
mousepointer | Excel Programming | |||
how can I embed an image in a cell so it moves correctly during so | Excel Discussion (Misc queries) | |||
MousePointer | Excel Programming | |||
Qn: MousePointer | Excel Programming |