Data Validation for ComboBox on userform...display MsgBox if value is false?

[Kamal1234]

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

[MickG]

Try this:-

Please Login or Register  to view this content.

[Kamal1234]

Many thanks Mick G! I have the MsgBox appearing twice when wrong data value is entered. Anyways I can make the msgbox appear once? Many thanks?