Simple Combobox error

**goldstandard** · 11-28-2011, 01:33 PM

Hey experts,

On a sheet titled "Database", I have a list of customers names in column A.
I have a userform titled "frmentry" and this form I have combobox titled "cbocustname".
I'm trying to make the combobox so that if a customer is added to the database the user will not have to adjust the code to see the customer's name in combobox.
Its something that seems quite simple but Im getting - "Error 13 - Type Mismatch"

Any suggestions? Thanks.

Please Login or Register  to view this content.

**Steffen Thomsen** · 11-28-2011, 01:43 PM

Try this

Please Login or Register  to view this content.

**goldstandard** · 11-28-2011, 02:08 PM

Thanks Steffen.
Tried the code...I now get error "1004 - Application-defined or Object-defined error".
Any suggestions?
Appreciate the response though.

**Steffen Thomsen** · 11-28-2011, 02:11 PM

Try this instead

Please Login or Register  to view this content.

**john55** · 11-28-2011, 02:13 PM

as an option

Please Login or Register  to view this content.

**goldstandard** · 11-28-2011, 02:19 PM

Steffen...your second code unfortunately did not work...same error. Thanks for the post though.
John...looks like you're the winner today. Thanks champ. Out of curiosity..any idea why my original code didn't work?