How to make Supplier_Name Visible & Invisible

[James Perry]

Hello Friends & Greetings!



In an Excel worksheet, using over 200 rows, i have in col A Supplier Codes & in col B i have the Amounts.

The Amounts get updated periodically; but the Supplier Code is fixed.
What I want Excel 2 do:
When I move the cursor over the Supplier Code, the Supplier Name gets visible.
But when I move the cursor away from the Supplier Code, the Supplier Name is then invisible.
The Supplier Names can b in another worksheet or workbook.
Cheers & thank u.

 

[Hui]

2 Questions

Where are the Suppliers names? Do you have a look up area somewhere

Where do you want the Suppliers Names to appear?

Would a Cell Comment holding the Suppliers name suffice?

 

[James Perry]

Hello Hui & thanks.
Typically, the Supplier Names would be in a different workbook or worksheet.
A cell comment would be too obvious to anybody moving around the workplace.
So, as i move the cursor over the Supplier Code, i would like 2 c the Supplier Name appear.
Much appreciated.

 

[NARAYANK991]

Hi James ,

You can make use of Jordan Goldmeier's rollover technique , which he has explained in his blog here :

http://optionexplicitvba.blogspot.in/2011/04/rollover-b8-ov1.html

If you download the work file he has uploaded ( http://optionexplicitvba.blogspot.com/2012/06/period-table-of-elements-in-excel.html ) , you can see the effect in action.

In case you want the effect to be done in your file , let me know.

Narayan

 

[James Perry]

Thank u Narayan 4 the link. I am checking that out.
Thanks again.