• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Prompting an error when user enters a certain value using VBA

G

gupta425

New Member
Hey,
I am a newbie to VBA, so please excuse me if the question appears to be trivial.
Here is my challenge;
I have a column for customer names, which are manually filled by my sales guys every time they meet with a customer
Unfortunately for me, sometimes the guys enter invalid data like "Vacation" or "Out of Office" in this column.
I wanted to produce a code in VBA, such that when they enter specific words like "Vacation" or "Out of Office" in that column, they are prompted through the Msgbox that they should not be entering that data.
Any fix on this? Would really appreciate it.


Thank you!
 
Last edited:
Hi ,

When you ask a question , especially if it relates to VBA , please post your workbook with data in it.

As for your present question , are the customers those who are already in a database or are they new customers whose data is being entered for the first time ?

If it is the former , then it would be better to validate the customer name from a database in Excel , so that no VBA is required.

Narayan
 
You must log in or register to reply here.
Back
Top