VBA Validation on Copy/Paste

[reshi]

Hello, I am new to ExcelForum and relatively new to VBA.

I am trying to validate multiple columns in a sheet that have multiple validation rules.

- Columns A and B need to only allow alpha values
- Column E needs to only allow the letter "X" or "x" or simply a blank
- Columns H and J must only allow positive whole numbers between 1 and 1000.


**I also need to ENSURE that these data validation rules stick even if someone copies and pastes data onto the sheet.

***If someone copies and pastes bad data, those cells should be highlighted.

Any help would be appreciated. Thanks

[stnkynts]

What do you mean by "alpha values"

Edit: I am going to assume you mean alphanumeric

[reshi]

strictly alphabetic. no numbers.

[reshi]

strictly alphabetic. no numbers.

can you provide some advice to my problem?

[stnkynts]

This should cover all the parameters you specified

Please Login or Register  to view this content.

[reshi]

My workbook is macro-enabled, but the code isn't stimulating anything? Am I supposed to place this within Worksheet_Change or just General?

[reshi]

just kidding, I figured it out.

I just entered "1.2" into a cell in Columns A and B. The code you created currently highlights ALL entered values regardless if they're incorrect or not. I just want those values that are incorrect to be highlighted.

[reshi]

Also, thank you so much for helping out. I really really appreciate it.

[reshi]

Just kidding again! I figured it all out. Thank you so so much

[stnkynts]

I am glad to hear everything worked out.