+ Reply to Thread
Results 1 to 5 of 5

Image Popup when mouse arrow hovers on Button

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    47

    Image Popup when mouse arrow hovers on Button

    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
    Attached Files Attached Files
    Last edited by ravinder_tigh; 10-06-2009 at 11:15 AM.
    Thanks & Regards
    Ravinder S
    (Ravinder_tigh)

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Image Popup when mouse arrow hovers on Button

    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.

  3. #3
    Registered User
    Join Date
    04-22-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Image Popup when mouse arrow hovers on Button

    Quote Originally Posted by D_Rennie View Post
    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
    Last edited by ravinder_tigh; 10-06-2009 at 01:24 AM.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Image Popup when mouse arrow hovers on Button

    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.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-22-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Image Popup when mouse arrow hovers on Button

    Quote Originally Posted by Leith Ross View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1