+ Reply to Thread
Results 1 to 3 of 3

Look up a description of an article when swiping over a cell

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    Sweden, Stockholm
    MS-Off Ver
    MS Excel 365
    Posts
    145

    Look up a description of an article when swiping over a cell

    I want to have a dialogbox presented when swiping over a cell.
    The dialogbox should pick up the text from a neiboursheet in same xls file,
    Attached document presenting the idea better.
    Grateful for ideas to sort it out.
    I konow I can add a text with a note, but the cell is in a toplist that can be varied depending the status of the list.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    1,463

    Re: Look up a description of an article when swiping over a cell

    This is not a simple solution. I used a hook to track the mouse cursor. To make the hook not work all the time you need to select a cell in the data range (I marked in yellow - range A1:A6). The data scope will automatically expand as the amount of data increases. At this point the hook is activated. Moving the mouse in this range, the mouse cursor will change to an arrow (xlNorthwestArrow). A tooltip describing the Article number should appear next to the data. If the mouse cursor is outside the data range, the cursor shape will change to busy (xlWait). This means that the hook is still running but there is no data to display. To disable the hook, select a cell outside the data range, the cursor will change to a standard cross (xlDefault).
    In testing, I noticed that even though the hook is running, the tooltip does not appear. Unfortunately, I could not find the cause. In this case, you should, until the effect, turn the hook on and off until the label appears.
    The code is only suitable for the 32-bit version of Office.
    WARNING: Do not debug your code when the hook is activated!

    A much simpler solution to the task would be to select each cell. Then the SelectionChange event will be triggered. We can read the value of the selected cell, look for the description in Blad2 and display a label with the result. The effect would be very similar to the file shown, but without the hook. But it would require selecting cells.

    Artik
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    1,463

    Re: Look up a description of an article when swiping over a cell

    Quote Originally Posted by Artik View Post
    In testing, I noticed that even though the hook is running, the tooltip does not appear. Unfortunately, I could not find the cause.
    I found the cause. Failure to clear the variable when disabling the hook. Below is corrected procedure:
    Please Login or Register  to view this content.
    Artik

+ 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] Drop List with a description but once chosen description disappear
    By dezspert22 in forum Excel General
    Replies: 22
    Last Post: 12-19-2016, 05:24 PM
  2. [SOLVED] Counting the article
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2013, 02:30 PM
  3. Can i save 350 word article inside a cell
    By georgiefame99 in forum Excel General
    Replies: 3
    Last Post: 03-30-2012, 02:18 PM
  4. Article Relabelling
    By montreal1775 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2006, 03:10 PM
  5. Article Relabelling
    By montreal1775 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2006, 02:29 PM
  6. Looking for a MSDN article.
    By Zoo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2006, 05:25 AM
  7. [SOLVED] Article creation
    By excelisfun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2006, 09:20 AM

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