Good Day
I have using this user form to add, edit, delete data. The userform thus far works brilliantly thanks to this forum and its members who assisted me.
I have this issue whereby when I am editing data, I want the system to check that the edited data is duplicated or not. The fields I am particularly concerned about are: ALB Tag# and the Power on Password and Computer Name
I have attached my spreadsheet for better clarity
Thanks
Something like:
Please Login or Register to view this content.
Last edited by mehmetcik; 05-01-2017 at 05:51 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
HI
Tried the code and getting error on txtTag.Clear "variable not defined"
Please Login or Register to view this content.
Last edited by bakerman2; 05-04-2017 at 01:33 AM.
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.
Please Login or Register to view this content.
Last edited by mehmetcik; 05-05-2017 at 01:06 PM.
@ mehmetcik
Code goes into debug on this line after typing first number.
Also still error on.Please Login or Register to view this content.
as OP responded in Post#3Please Login or Register to view this content.
My Mistake
Try this instead
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks