Autocomplete question

Hi, I have a combobox in workbook A linked to Workbook B, Workbook B has 5000
names so it's dificult to find the name using the combobox because of the
combobox lenght, I want to be able to put some letters of the name so when
those letters matches exactly with the name, appears in black the missing
part of the name (like excells autofill but betwen workbooks).
Any suggestions???

Also:
I'm from Mexico but I'll travel to LA on july and I want to take a VB course
and/or certification, Do you know somewhere where I can take this course???

If the names in Workbook B are sorted, and it's the first few characters
of a name that you enter, you might find the name by entering the
characters into an inputbox when you double click on any cell in a
specific sheet in Workbook A
MATCH Worksheet Function in a macro as a substitute for hyperlinks,
in a a name and address list. (#match)
http://www.mvps.org/dmcritchie/excel/event.htm#match
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"filo666" <[email protected]> wrote in message news:[email protected]...
> Hi, I have a combobox in workbook A linked to Workbook B, Workbook B has 5000
> names so it's dificult to find the name using the combobox because of the
> combobox lenght, I want to be able to put some letters of the name so when
> those letters matches exactly with the name, appears in black the missing
> part of the name (like excells autofill but betwen workbooks).
> Any suggestions???
>
> Also:
> I'm from Mexico but I'll travel to LA on july and I want to take a VB course
> and/or certification, Do you know somewhere where I can take this course???