VBA to validate cell input?

[TheWennerWoman]

Hello,

Is it possible to validate user input into various cells? For example, Range C3:J3 is merged to create a cell where the user enters their name. Range C4:J4 is merged for them to enter their address. When they exit each range, I'd like to run some code to validate that they haven't entered anything like a comma or a speech mark (the data ultimately ends up in a database and I'm trying to keep it as clean as possible). If they have, I can just pop up a message box telling them what they need to correct.

Any thoughts appreciated.

 

[Joe4]

I would recommend just using the built-in Data Validation. You can easily also set your own custom messages with Data Validation.
If you choose the Custom option, you can enter a formula like this for cell C3:

=COUNTIF(C3:C3,",")+COUNTIF(C3:C3,CHAR(34))=0

Note that CHAR(34) is the ASCII equivalent of ", which is what I assume you mean by "speech mark".
If you meant single-quote and not double-quote, you can use this instead:

=COUNTIF(C3:C3,",")+COUNTIF(C3:C3,",")=0

Also note, I HIGHLY recommend removing your merged cells. Merged cells are absolutely horrid and cause all sort of issues for Excel VBA.
It looks like you are just centering across rows, and the "Center Across Selection" formatting option gives you the same visual effect without all the issues that merged cells cause.
See here: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis