Hello guys,
I created a user form which is displayed when opening the excel file.
I set conditions to ensure the completeness and correctness of data entered. The conditions are as follows:
- All text boxes should not be blank (no issue with this one so far)
- Text box1 ( name) : only text can be entered. If not display the message box ( I was stuck with this one ). You can refer to the code below ( for some reason I'm not able to enclose the file in the post)
- Text box2 ( done by) : Initials should be entered. For instance JH for "John Smith" . The initials entered shoud be made up of at least 2 letters and capped to 3 letters.I used loop to display a message box until the condition is met but I failed)
- Text box3 ( Date) : only date format is accepted ( I want to make sure no other info is filled )
I'm a newbie on this field and I was stuck for some hours trying to figure out that by myself but now I'm seeking a solution for this challenge.
Thanks in advance
Bookmarks