+ Reply to Thread
Results 1 to 3 of 3

Show image on mouse over in another cell

  1. #1
    Registered User
    Join Date
    01-14-2011
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    11

    Show image on mouse over in another cell

    Hello everyone.
    A week ago I decided to create a list which will contain the card names from a card game I play.
    Once this was finished I thought it would be great if I could have a image of the card appear in a different cell than the name.
    After checking the last days several threads about this topic, I gave up. My programming knowledge is limited to Fortran and C++,
    but even this was almost 7 years ago, and most of the examples I found were done for Excel 2003 or even earlier and not 2007.
    So they require changes I'm not sure how to make them work.

    The data on the sheet are presented in a simple way: Filename[Column A] - Name - Type - Cost - ... - Text [Column K]
    The idea is to display the image in column K when the mouse moves over the cell which has the filename of the image as it is stored in a folder.
    If it is difficult to show the image on the K cells, then a fixed cell will also be ok.

    Can someone direct me to a thred that addresses the same issue or maybe provide information about where I should look to solve this,
    so I can get finallysome sleep? Thanks in advance.

    Cheers,
    Kostas

  2. #2
    Registered User
    Join Date
    01-14-2011
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Show image on mouse over in another cell

    After searching some more I found the answer to thread here:
    http://www.excelforum.com/excel-prog...=1#post2148940

    I have 3 problems.
    1. Since I don't know much about macros and VBA, I don't know how to use it in my sheet with the list.
    2. The only way to make the images disappear is to move all the way down to C7.
    3. I get some Runtime errors when I move the mouse on C6 from any cell other than C5, or if I move on any cell after I went through C4->C5->C6->C7

    I think I read somewhere that ActiveSheet.Shapes does not work in 2007, so I assume this is causing the issues with the image not disappearing and the Runtime errors.
    If it is easy, can someone here guide me through the steps to use it on my list.

    Thanks,
    Kostas
    Last edited by kkostas; 10-15-2012 at 01:14 PM.

  3. #3
    Registered User
    Join Date
    01-14-2011
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Show image on mouse over in another cell

    Someone please?
    In case you are wondering what the module is, I'll post here

    Please Login or Register  to view this content.

+ 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