Assign a macro to a column

[mmartinez13]

How do I assign a macro to a column?

What I would like to do is assign a macro to a column ensuring the correct data is entered. If the incorrect data is entered, I would like a messagebox to open, prompting the user to correct the data in that particular cell, ingnoring blank cells that have not been reached yet.

Thanks again in advance for all your help.

 

[jmthompson]

It could be done, why not use data validation?

 

[mmartinez13]

Jen:

I am currently using the data validation function, but, as the operator enters data (via scanner), the program moves extremely slow. I believe all the formula within the worksheet is a contributing factor of this.