madchemist
Board Regular
- Joined
- Jul 10, 2006
- Messages
- 198
I have a macro that inserts data from a userform into a row and also sets validation on several cells. One cell that corresponds to a text box on the userform (so users can enter whatever they want) has validation set to make sure it is a decimal between 1.01 and 10.99.
The validation works find if I try and change the cell, but if the user enters an initial value in the cell that is out of the range, it gives no error....
Is it possible to make the macro validate the data? Or do I need to restrict the values that can be entered on the userform somehow, perhaps using a drop down menu or something? I would prefer to not use a drop down menu, as there is a lot of data and would be time consuming scrolling...
Thanks!
The validation works find if I try and change the cell, but if the user enters an initial value in the cell that is out of the range, it gives no error....
Is it possible to make the macro validate the data? Or do I need to restrict the values that can be entered on the userform somehow, perhaps using a drop down menu or something? I would prefer to not use a drop down menu, as there is a lot of data and would be time consuming scrolling...
Thanks!