Hi All,
I have set data validations to many cells of my workbook, and they work great when the user inputs information into the cells, but when you copy and paste into the cells containing data validation, the cell properties are over written to where there is no longer data validation. As i understand this is what data validation is designed to do, but is there some way via VBA to make it where a user can copy paste values into cells with data validation and they are still run through the validation to see if the value fits the requirement. I have been given suggestions on how to make it so the user cannot copy and past values, but for my worksheet the user will need to input <= 200 numbers into a sheet, therefore it would be much more efficient to them to just copy and past the numbers into the 20X10 grid i have unlocked for them. the reason i say <= 200 numbers is becuase of my data validation, the amount of numbers that they can enter is based on a criteria that they give me to start the worksheet. I have data validations in this grid that say the data entered has to be a number and less than the number they input before, so i cannot use any sort of VBA code that just checks if the pasted value is a nunmber(Have been given this code in the past). I am really looking for something that can read the numbers as they are pasted in and can run them though the current data validations in each cell, becuase each cell has a different data validation. This may not be possible, but any insight will help me. I am very new to VBA, so please if you do have a solution paste your code and a little explanation of what it is doing, so that i can just copy and paste it into my worksheet and change the values to fit my needs.
Thanks in advance for any help,
I have set data validations to many cells of my workbook, and they work great when the user inputs information into the cells, but when you copy and paste into the cells containing data validation, the cell properties are over written to where there is no longer data validation. As i understand this is what data validation is designed to do, but is there some way via VBA to make it where a user can copy paste values into cells with data validation and they are still run through the validation to see if the value fits the requirement. I have been given suggestions on how to make it so the user cannot copy and past values, but for my worksheet the user will need to input <= 200 numbers into a sheet, therefore it would be much more efficient to them to just copy and past the numbers into the 20X10 grid i have unlocked for them. the reason i say <= 200 numbers is becuase of my data validation, the amount of numbers that they can enter is based on a criteria that they give me to start the worksheet. I have data validations in this grid that say the data entered has to be a number and less than the number they input before, so i cannot use any sort of VBA code that just checks if the pasted value is a nunmber(Have been given this code in the past). I am really looking for something that can read the numbers as they are pasted in and can run them though the current data validations in each cell, becuase each cell has a different data validation. This may not be possible, but any insight will help me. I am very new to VBA, so please if you do have a solution paste your code and a little explanation of what it is doing, so that i can just copy and paste it into my worksheet and change the values to fit my needs.
Thanks in advance for any help,