Combobox (ActiveX) : How to prevent users to enter value not included in ListFillRange ?

[francois.lemarie]

Hello,

I would like :
- to force users to select a value of a Combobox (my values are in ListFillRanges yet) (if they don't do it, it must be error).
- to prevent users from entering, in a combox, other values than the indicated.

Any way of doing it ?

 

[sykes]

In design mode on your sheet, right click the box, and select "Properties."
Set the "Style" property of the box to "2", and the "MatchRequired" property to "True."
Exit design mode.

 

[francois.lemarie]

Thanks a lot, it's perfectly what I needed !