Hi all,

How can Data Validation be applied to a ComboBox on a userform for data entry purposes.



For example. My ComboBox has a dropdown list with two values, Y and N.



If a user enters a value which is not Y and N then a MsgBox will show.

Can this be done using a IF statement to ensure, if values Y or N is not entered then
a msgbox will appear etc..



Many thanks!

Kind regards,

Kamal1234