Create a tooltip displaying the contents of a cell in VBA for Excel 2003
Posted on 2012-04-10
In a worksheet, I have a column that reads and displays the content of cells from another worksheet. As my column is too narrow to display the whole information, I wrote a VBA macro that would display that actual contents when right-clicking the cell and selecting the macro in the shortcut menu.
However I was wondering whether I could create in VBA a tooltip that would do the same just when hovering around the cell using the mouse.
Any idea for me to get started?
Many thanks in advance for any clue.