ComboBox Help

[Quicksnot]

thanks for taking the time to read my post

Hi, the combobox works with most of the Team, but not with all the teams
could someone look at the code and tell me whats wrong, why most of the teams work
but some doesn't.

new.xlsm

Thanks
Keith

[tigeravatar]

Quicksnot,

The problem is mispellings. You populate the combobox with the list in column A on sheet 'TEAM'. So you have "JOEYS ON LATHROP" in the list, but in sheet 'PLAYERS' it is called "Joey's Lathrop". The search isn't case sensitive, but the "on" doesn't exist and the apostrophe is missing. The other errors are for similar reasons.

[Quicksnot]

Awsome and Thankyou it was driving me NUTZ

was a code i got from this awsome Forum and being a newbie i couldn't figure it out

Thankyou so much

gonna mark this solved, but i have a ton more problems with the form and i've asked alot
of questions with no replies, because i thinks its me not explaining what i'm trying to do correctly.

you seen the workbook, and was kinda wondering if you understand what i'm trying to do with it.

if you can be more help it would be deeply appreciated.

Thanks
Keith