+ Reply to Thread
Results 1 to 4 of 4

Picture popping up when a cell is "mouse over" or selected

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    Norway
    MS-Off Ver
    2016 (Win10)
    Posts
    76

    Picture popping up when a cell is "mouse over" or selected

    Hi, we are using excel 2016 and files used are normally xslx or xslm.

    I am trying find a way that will pop up a picture (snapshot of a table) when user move mouse to specific cell or select the cell. I cannot use drop down list in data validation because the cell already contain a list. The picture is to help user to decide which to select.

    We don't like the input message in data validation because the box is too small and unable to format message into a manner for easy understanding. For example, we wanted the message to look like this (row by row):
    mgrp_SS1 = sgrp_AA2
    mgrp_RS2 = sgrp_RR3

    but using the input message, visually it looks like:
    mgrp_SS1 =
    sgrp_AA2
    mgrp_RS =
    sgrp_RR3

    The size of the box, split the sentence into two which makes the message not as clear cut and straightforward.


    Thats why I thought we can compile the message into a table (row by row), snap shot the table to add in as tooltip when cell is selected or hover over.

    I hope we don't have to use VB for this but if there is a need to use VB, I hope it will be a simple one because there is no strong VB knowledge people in the office.
    Last edited by fornight; 04-12-2018 at 06:21 AM.

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Picture popping up when a cell is "mouse over" or selected

    Comments have the functionaity to show on mouse-over. and you can put a picture in a comment.

    on the site contextures.com is a how to
    The steps are:
    1. Right-click the cell which contains the comment.
    2. Choose Show/Hide Comments, and clear any text from the comment.
    3. Click on the border of the comment, to select it.
    4. Choose Format|Comment
    5. On the Colors and Lines tab, click the drop-down arrow for Color.
    6. Click Fill Effects
    7. On the picture tab, click Select Picture
    8. Locate and select the picture
    9. To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio
    10. Click Insert, click OK, click OK

    ofcourse you could also consider just to list the options in the comment

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Picture popping up when a cell is "mouse over" or selected

    I found another way, I think better because it looks more like a dropdown list
    You can remove the datavalidation and replace it with an Axtive X combobox. The combobox is in the Develop menu but NO vba is needed to make it work
    you just need to change some properties to show multiple columns.

    please follow the instructions in the attached workbook to make it work in your sheet.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-21-2017
    Location
    Norway
    MS-Off Ver
    2016 (Win10)
    Posts
    76

    Re: Picture popping up when a cell is "mouse over" or selected

    This is GREAT!!!

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display Picture "A" or Picture "B" based on value in Cell A1
    By JET2011 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-18-2015, 06:53 PM
  2. Replies: 0
    Last Post: 03-21-2014, 09:58 AM
  3. Preventing the "Do you want to save the changes you made..." from popping up.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2011, 01:14 PM
  4. if "a" selected from dropdown menu then show "K" in other cell
    By LEGALMATTERS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 01:10 PM
  5. Replies: 2
    Last Post: 03-16-2006, 02:55 PM
  6. prevent Excel from popping-up an "OK" (information) message
    By crimsonkng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2005, 06:05 PM
  7. Replies: 3
    Last Post: 06-20-2005, 06:05 PM

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