Populate a ComboBox

[zplugger]

Trying to change a textbox over to a combobox,thetextbox does a data search to find a name. I hope
a combobox would populate with more of the same names then narrow down to one. So if there was
six Jims it would show all until last name is typed in. Here is the code for the textbox all I changed was the textbox to combobox. Not
sure how to populate the comboBox? Attached is a workbook of what I would like to do.
Z

Please Login or Register  to view this content.

[john55]

maybe a listbox could help you...
see here an option
http://www.excelforum.com/excel-prog...html?p=2905521

[zplugger]

Have a listbox now, want to have combobox populate more choices for the listbox?

[cplmckenzie]

zplugger,

what version of officxe are you using?

cplmckenzie

[zplugger]

Excel 2007

[cplmckenzie]

zplugger,

I have some working code which uses this. I will look at your file over the weekend.

cplmckenzie

[zplugger]

Does anyone know if this is possible, or should I give up on this idea?
Z

[zplugger]

going to mark thread solved,just don't think it can be done. Trying to look up
two different fields with same combobox seems impossible. I will try and do it with two boxes, a
combobox,textbox.
Thanks Z