Hi,
I am totally new to VBA and started my carrier just now. I have a excel that contains tables. In the table all the cells have data validation. I need to write a code to avoid invalid data entries in the cells. If i just type other than the entries that are in the data validation list it will throw an error but if i copy and paste from another excel or notepad it is allowing the invalid entry.
So please help me how to avoid this.
Thanks in advance.
I am not good in VBA but if you upload a sample workbook with enough sample data in it along with the code you are using, other members may offer you a solution. Because this forum has many VBA experts who can look at the issue you are facing. Without looking at your workbook and the code you are using, its hard for anyone to suggest you a solution.
To upload a sample workbook click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi,
I have attached my working excel. Data validation contains from Account to Device type
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks