From XL-Dennis we have an entry that uses a VLOOKUP in Visual Basic [VB]!
“I thought it would be interesting to create a case and see how VLOOKUP can be part of VB-solutions. Actually, for several years ago I did similar solutions but with classic VB (VB6) for a customer. Imagine that we have a price list for our products. Because of the frequent price updates the company has decided to store it in a MS Excel workbook.” … To Read More Click Here to go to XL-Dennis’ Lesson.
Among other places around the Cyber-Globe, XL-Dennis may be found at The VSTO & .NET & Excel Blog