how can I restrict what characters are allowed in an activex field?

[Joe Patrick]

I'm exporting the data to a text file so certain characters cannot be used:
/ \ : * ? " < > |

How can I prevent users from entering those characters?

Thank you!

[macropod]

Hi Joe,

You could prevent the invalid characters being typed into the ActiveX control by adding the following sub to it:

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Select Case KeyAscii
  'Prevent input of: / \ : * ? " < > |
  Case 47, 92, 58, 42, 63, 34, 60, 62, 124
    Beep
    KeyAscii = 0
  Case Else
End Select
End Sub

Note: There's probably a whole range of other invalid characters, but I've limited the 'exclusions' to those you mentioned.

[Joe Patrick]

Paul, once again, thank you so much!