TextBox validation

[Whistler]

Hello Guys,

I have a UserForm where users adding sdata to the table via a textboxes.
One of the textBox can contain only names which are in second table.
How to validate this TextBox?

I need something like below:

If Table containts then return true

Thanks

PS. Im new in VBA, pleas be patient

Thanks very much

 

[Whistler]

For clarificatrion, I managed to write method which will prompt message box and set focus if false is return, and here I have a problem.

I need:
If Table contain TextBox.Value then return true

Thanks

 

[Whistler]

I search few forums and I cannot find this anywhere, I only found numbers or email validation. Anyone?

 

[Whistler]

I stuck with this for last 5 hours! Please help me

 

[Whistler]

refresh

 

[Whistler]

I have managed to resolve it, but I am having antoher problem, Excel is finding Name in tables but only if I inpit to the textBox name without space between name and surname. Any idea?

Private Sub NameBox_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim ws3 As Worksheet
Dim aTable As Range
Set ws3 = Worksheets("Names")
Set aTable = ws3.Range("A:A")
Set c = aTable.Find(NameBox.Value)
If Not c Is Nothing Then
MsgBox "The name is not valid. Please check for taping mistakes or re-enter."
Cancel = True
With NameBox
.SetFocus
End With
End If
End Sub

Thanks for any help