Autofill linked
 

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???

Autofill linked
 

Using a combobox with the property Match Entry set to complete. If the list
is sorted than when you start
typing the selection will move to the first entry in the list beginning with
what you type. You can continue to
type or use the up/down arrows to move the selection.

Something similar happens if you use a listbox. Except you can set the
height on the list box to show several
rows from the list and navigate more easily.

Again - the key is to use a sorted list fill range.

--
steveB

Remove "AYN" from email to respond
"filo666" wrote in message
...
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???