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.

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

Originally Posted by Artik

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