Hi, everyone I've got yet another problem with my data form that I've made In VBA, I Want A Text Box Which Data Is Entered To Only Allow The Following values "20" and "40" And If Any Other Is Entered A Error Message Coming Up Saying "You Can Only Enter 20 And 40!" Here the Code I Currently Have And Would Appreciate Some Help Thank You!
Private Sub txtContainerType_Change()
Sheet1.Range("B19").Value = txtContainerType
End Sub
Private Sub txtContainerType_Change()
Sheet1.Range("B19").Value = txtContainerType
End Sub