Hi everyone,

I am at the end of my string. It has been years since I have used
VB and I am using Excel for the first time. My programing background
and has made most things very easy, however... I would really like to
use VLOOKUP to search an inventory and return the closest match. But
most of you probably know how useful VLOOKUP is when an exact match is
not found. So I decided to use comboboxes because they have an
autocomplete function which is just brilliant when dealing with
hundreds of different items.

So the question is: how can I make user creation of additional
comboboxes, which are pre-linked and already have their ListFillRanges
assigned, possible?

Alternatively, can VLOOKUP or some other function be modified to
provide closer, more intuitive returns?

Cheers,

Busta