Hello,
I want to be able to restrict the data type that can be entered in range "Q5:Q6267". Only the value "BKS" and "" (empty cell) should be allowed, anything else should trigger a message that i will create. I dont want to use the data validation process, i want to do it in VBA coding. Below is what i have so far but it doesnt work, can you tell me what i am doing wrong, thank you.
Please Login or Register to view this content.
Bookmarks