Excel Form Validation Using VBA

[sebhughes]

I have a form with a text field, and if it contains the Character * anywhere in it I want msgbox to come up saying it is not allowed. How can I do this?

 

[sebhughes]

anybody?

 

[phxsportz]

use the INSTR() Function

example

A = "12*"

instr(A,"*") would return 3

so use something like

If Instr(Your_Text_Box_NAME,"*") > 0 Then
POP A MESSAGE, BEEP, Return to Code, Whatever you want to do
ENDIF