Hello all, I dont know if this is possible, I have a file with one worksheet called Suppliers, Quotes and Invoices. I can type up to 24 suppliers in a list and on the quotes form bring up one of those suppliers using the match & index code by entering S01 to S24. I was wondering if there was a way where I normally type in the code S01 to S24 in my quotes form, you simply float your mouse over the cell, and possibly a list could appear onscreen showing the S01 to S24 companies and addresses - then if highlighting one, the detail would be entered in the cell for you? I have put a very crude example of the type of thing I am asking for and would alter the vba to cover the exact range where the addresses are normally kept. Thanks
Bookmarks