Hi, i have a text box on a slide, where a user enters a sentance, i would like to prevent the user from entering a , value into.

So far i am using the following code:
Code:
    If Slide15.TextBox1.Value = "," Then
    MsgBox "Invalid Character Entered. You Cannot Enter , Value.", vbOKOnly, "ERROR"
    End If
This displays an error if only a , value is entered, but i need an error to be displayed if the user enters a comma value as part of a sentance, for example "Hi, thank you".

Also, i have code running after this, which takes the user to the next slide, but i only want this part of the code to be run if there is no , value in the textbox.

Any help would be much appreciated.
Thank You