Results 1 to 7 of 7

Image Pop Up on Mouse Hover over image on userform

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Lightbulb Image Pop Up on Mouse Hover over image on userform

    So I have this form containing multiple images for user selection. The images are shrunk down to enable the user a quick overview of the types of images. What I want to achieve is - when the end user hovers over any of these images/frames - a modeless userform will pop up displaying a much larger version of the same image.

    This alone would be challenging enough but there are some other points I want to look at:
    1. The popup form must be modeless. If the user moves the mouse away on the original form, the popup form must close. = PARTLY WORKING (DOUBT THIS CAN BE FULLY IMPLEMENTED). I initially tried measuring the mouse pointer in relation to the form but it had a lot of problems. So I was forced to call a sub from the mouse hover function of each control. The problem I have found is that the mouse hover function only works if the control is uppermost. Meaning if the popup form covers the control on the original form, the mouse movement is only read from the 2nd form not the 1st. Am chalking it up to a VBA technical limitation and moving on.
    2. If the user closes the original form, the popup form must close also. = PARTLY WORKING. I feel as though I am repeating code unnecessarily. I would like a single exit point but am not sure where this would go. Also sometimes the popup gets stuck but that
      is an issue with objective 4.
    3. The original form has dynamic size/positioning of images/frames. Not sure how this will play out with the 'mouse hover over image' code? = PARTLY WORKING. The popup matches the aspect ratio of the original image but I would like it to resize to most of the desktop area. I need to merge the 'resize form based on picture' concept from an earlier form (frmShowPicture) with the 'almost fill desktop area' concept used in frmShow10Pictures.
    4. Optional but nice to have - the pop up form should auto close after X seconds. = PARTLY WORKING. Occasionally the popup form insists on finishing its loop even after it has received the instruction to exit. I don't know why. Thinking I should open a separate thread to tackle this particular side issue.

    I don't expect to achieve all of these at the first attempt. But help on any of these aspects would be appreciated.
    Attached Files Attached Files
    Last edited by mc84excel; 03-31-2019 at 05:00 PM. Reason: Upload extract for testing and update progress
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inserting image into userform label, text behind image?!?!
    By spyrule in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-31-2016, 03:23 PM
  2. Replies: 1
    Last Post: 07-14-2016, 04:59 AM
  3. [SOLVED] Using a Userform to Browse image file then paste selected image to sheet?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2015, 05:42 PM
  4. [SOLVED] How to apply Image borders to an image that my excel vba userform pastes in a word doc?
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 05:40 PM
  5. [SOLVED] VBA to transfer image FROM userform image control TO a worksheet cell
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 02:51 PM
  6. Replies: 3
    Last Post: 01-06-2010, 02:16 PM
  7. How to add hover tips to image buttons?
    By PeteTheTool in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2009, 11:54 PM

Tags for this Thread

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