Hover Messages
MS Excel 2003, Workbook name €ś2008 Results.€ť
In worksheet named €śInventory,€ť Column M has alpha-numeric codes - the
worksheet contains 8000+ rows.
In worksheet named €śFunction Codes,€ť 365 a-n codes are held in column B,
with their corresponding text descriptions in column C.
What is needed: when the user hovers the cursor over a cell in €śInventory€ť
column M, Excel finds the a-n code in worksheet €śFunction Codes€ť column B,
and displays the corresponding text from column C the same way as in a
hyperlink €śScreen Tip.€ť
Finally, the user must be able to click on a column M cell, make an a-n code
change, and the new text description appear when hovering over the changed
cell (after the correction has been entered).
What would the macro code be and where would it be placed?
|