user form - drop down set values

B

Boss

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
 
R

Rick Rothstein

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)?
 
Top