Image Popup when mouse arrow hovers on Button

[ravinder_tigh]

Hi Guys

I'm Quite new to VBA Programming n working on a project facing one Obstacle regarding that

I don't have any problem regrading the project but my Problem starts when i tried to make my tool more user friendly

i tried to put comments on conditional cells in form of images but i also want to put these Image POPUPS on buttone also what i desired is when ever mose arrow hover over a button a image pop should appear

i' tried to google it but of no use

I'd be highly indebted if any one could please help me regarding this problem i'm attaching a dummy file for better under standing

Thanks a Lot

Regards
Ravinder Singh

[D_Rennie]

Easy option is to use activeX controles they have a mouseover event.

I didnt have a lot of luck without activex though could change picture of button with,

Please Login or Register  to view this content.

intresting though

hope this help.

[ravinder_tigh]

Easy option is to use activeX controles they have a mouseover event.

I didnt have a lot of luck without activex though could change picture of button with,

Please Login or Register  to view this content.

intresting though

hope this help.

Thanks a Million D_Rennie that was really a quick reply
but i had tried this option by the help of this was able to change the picture of the button

but didn't get the desired result
i want when ever mouse is over the button a full size image appears just like in the Help file ver 1.0 file attached in which when i go to cell named help a image appears on side(Image is on comment) whn i move cursor image disapppers tht's wht i want to do with button also


could u please help me with
set foucs and lost focus in this case

Regards,
Ravinder Singh

[Leith Ross]

Hello ravinder_tigh,

I added a Auto Shape to "Sheet1". It is named "Rectangle 4". The shape is displayed whenever the mouse moves onto the CommandButton1 and disappears when the mouse leaves the control. You need a certain amount of space between the shape and the control. If the two objects are too close then the shape object won't go away properly. The macro below has been added to the attached workbook. It uses the Mouse_Move event to display and hide the the shape.

Please Login or Register  to view this content.

[ravinder_tigh]

Hello ravinder_tigh,

I added a Auto Shape to "Sheet1". It is named "Rectangle 4". The shape is displayed whenever the mouse moves onto the CommandButton1 and disappears when the mouse leaves the control. You need a certain amount of space between the shape and the control. If the two objects are too close then the shape object won't go away properly. The macro below has been added to the attached workbook. It uses the Mouse_Move event to display and hide the the shape.

Please Login or Register  to view this content.

thanksssss alotttttz Ross its working perfect