user form - drop down set values

  • Thread starter Thread starter Boss
  • Start date Start date
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
 
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)?
 
Back
Top