tallpaul321
New Member
- Joined
- Mar 7, 2002
- Messages
- 5
I have a textbox on a userform in visual basics which will have the date manually typed into it. When the OK button is pressed the date is cut and pasted into a cell in Excel. Is there any way to validate the textbox to prevent an incorrect date being inserted? I have tried validating the cell that the date is pasted into but if an incorrect date is entered the debug box is displayed.