TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
Is it possible to validate user input into various cells? For example, Range C3:J3 is merged to create a cell where the user enters their name. Range C4:J4 is merged for them to enter their address. When they exit each range, I'd like to run some code to validate that they haven't entered anything like a comma or a speech mark (the data ultimately ends up in a database and I'm trying to keep it as clean as possible). If they have, I can just pop up a message box telling them what they need to correct.
Any thoughts appreciated.
Is it possible to validate user input into various cells? For example, Range C3:J3 is merged to create a cell where the user enters their name. Range C4:J4 is merged for them to enter their address. When they exit each range, I'd like to run some code to validate that they haven't entered anything like a comma or a speech mark (the data ultimately ends up in a database and I'm trying to keep it as clean as possible). If they have, I can just pop up a message box telling them what they need to correct.
Any thoughts appreciated.