I've Made A User Form And I Need Help With Validation

[Morrissey]

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

 

[Audiojoe]

It's on the way...

Sbirro Cornuto, I just have to go drain the main vein, and then I'll have a look. Don't put too much faith in me though man, when God dealt out skills to me at birth, he gave me guitar, lovemaking, manhood size and chiselled good looks. VBA was number 7, behind glass blowing and the ability to sleep...
This message was edited by Audiojoe on 2002-03-20 07:13