If statement to force user to insert 4 specific strings

[IceSnakeR]

Hello,

I need some help with an userform, i`m fairly new to vba coding so bear with me . I have a "ComboBox1" created in the userform, i`ve used the "row source" property to alow a user to select only four strings from a range in excel. My question is:

Can i use an if statement to force the user to select only the four strings present in the excel range? At the moment an user can type other things too. I would like that he would receive a message (MsgBox("input error") if he inserts something different from the presented options.


Thanks,
Chris

 

[IceSnakeR]

I`ve found a workaround, i modify the combobox style to DropDownList.