You will probably be better off in this situation to use Conditional Formatting and/or Data Validation to ensure correct input. If a user doesn't enable macros then your warning messages won't appear.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save