Run-time error 1004 when coding in-cell dropdown

[excell_rookie]

Dear forum,

I´m trying to code a in cell dropdown list.

First I recorded a macro, and after that, I´m trying to ustomize the code for VBA

Please Login or Register  to view this content.

when I run debug (F8) this code

Please Login or Register  to view this content.

gives

Run-time error 1004
Application-defined or object defined error

I would appreciate your help solving this problem
Thanks in advance

Regards
Peter

[Norie]

Peter

Should you not be using the address of rngList preceded by '=' when adding the data validation?

[excell_rookie]

Thanks for your answer Norie,
the right way is

Please Login or Register  to view this content.

[Norie]

Peter

That would only work if you have a named range called 'rngList'.