Would changing the Style property of the ComboBox (what I assume you are
using when you say "drop down" on a UserForm) to 2-fmStyleDropDownList in
the Properties box be an acceptable alternative (it will not let the user
pick anything that is not on the list)?

--
Rick (MVP - Excel)


"Boss" wrote in message
...
Hi,

I have dropdown (coprocess.List) which pulls data from below code...
coprocess.List = ThisWorkbook.Sheets(1).Range("CL7:CL16").Value

I wish it should give me a error or message when user puts something which
is not in the drop down.

Thanks!
Boss