Tag Archives: Visual Basic

From XL-Dennis: “Using VLOOKUP in VB”

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

Advertisements

Jorge Paulino “Excel: Dicas de VBA – vLookupValues() uma Variante do Vlookup()”

From Jorge Paulino, Microsoft Visual Basic MVP, an addition to the VLOOKUP WEEK em Português!!

Though not fluent in Português, there is quite a bit of Code associated with this entry so we have designated it Intermediate to Advanced VLookup. We thank Jorge for his contribution. We will, however, leave the commentary on the submission to our Português Speaking viewers.

Find out more about Jorge Paulino at The MSDN Blog or his website JorgePaulino.com