Allow specific text in a textbox

[Pacman52]

Hi
I'm just fine tuning an Exit sub routine, could someone let me know if it's possible to only allow the specific text value "N/A" to be entered in a textbox BUT to exclude all other text values?

Many thanks

Paul

 

[DanteAmor]

This is what you need?

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
  If TextBox1.Value <> "" Then
    If TextBox1.Value <> "N/A" Then
      MsgBox "Only allowed N/A"
      Cancel = True
    End If
  End If
End Sub

 

[Pacman52]

Hi thanks for your help - again.

Sorry I took so long to reply been away. I'm assuming '<> ' is for less than or greater than which makes sense to use instead on '=' but what was confusing me is why '<>' was used again but as I was typing this reply a lightbulb came on in my head and I actually got what the code is doing lol.

Thanks again Paul

 

[DanteAmor]

'<> '

That operator or symbol will be used for the opposite of '='
To know if it is different from.

In the following example compare if a is equal to b
a = b

And in the next example compare if a is different from b
a <> b

I hope it is clearer.