Wouldn’t it be great if you could use this autocompleting feature to search for data? Well, you can. I’ll show you how to combine this behavior in Excel in a combo box with a VLOOKUP() function.

For instance, can you conditionally format the selected value in a combo box control? The answer is yes, but you won’t use conditional formatting; you’ll use a VBA procedure. In this article ...