Hello,
I would like to add the following ability to my spreadsheet. When there is a unit number populated in a cell, i would like to either double click on it, or hover the mouse over the unit number and be able to see information on the unit in a quick flash message. I do NOT want to populate the information in the spreasheet, just be able to refer to it and keep working.

I have the information I want to display in another workbook and it would be simple enough to do a vlookup on the unit number and find unit type, unit year, unit status. However I want the information to come up in the form of a msgbox or Control tip text.

Can anyone coach me on how to do a lookup in VBA?

Thanks,
Todd