VBA Program

I am doing a program in VBA and running it in Microsoft excel.

For example,
when typing the input, the user is supposed to type “234-L1-23-23”. Instead, if the user typed “234 – L1 – 23 – 23″(The error is the spacing) the whole program hangs.

my question is this, is there any way of programming in VBA can solve this error?? or Is this error can be avoided if the C++ program were used instead of VBA.