Excel VBA - I want a regular expression pattern to validate name field in using macros
===

I have the following requirements for validating an input field:

    It should only contain alphabets and spaces between the alphabets.
    It cannot contain spaces at the beginning or end of the string.
    It cannot contain any other special character.

For example,

the expression should accept the following string "my name is wish"

the regular expression which I'm using is 

RegExp.Pattern = "^[\a-zA-Z]*[\s]*[\a-zA-Z]*[\s]*[\a-zA-Z]*$"

the problem with this is that when i enter a name as "abc abc abc6" then it accepts it as valid but what i want is that it should give an error as number is enetered.

Anyone can please help me on this.
