Hi I have the attached code that I found in internet however I has not been able to get it work.
Basically I want to enter data to sheet Customers using VBA (Userform). The rule is that if the customer Id already exists, inform the user and clear the Textbox so they can enter a new valid customer id.
Thanks,
Check the attached file
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you Sixthsense, It is not working. Once I enter a new item, I get the message "Customer ID Created Successfully" however when I close the UserForm the other message "Customer already exists" comes up, and the new customer Id is not listed.
Can you please check if something wrong in the code?
Thank you!
Remove the AfterUpdate sub and only use this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you Bakerman2, that worked great.
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks