In this video learn how to avoid submitting Duplicate Entry in Userform in Excel VBA. Very informative video for student and developer at beginning stage
Thanks. It is very helpful. Would it also be possible, if a user enter the same Reference Nr and message should display, "Reference Nr" exists, do you want to save the Reference Nr as a new Refeference nr. If the User enter the yes option the new record should be save in the database. Could you please show this senario. User should not enter the new reference nr; the new Reference nr should be incremented automatically after clicking the yes option. Hopfeully i explained correctly. Thanks in advance
I used the no-repeat code, but it didn't work. Every time I try to edit and save it, it sends me a message. This name has existed before and cannot be repeated. Of course, I do not want to add, but I am trying to modify some data Because when I try to edit, I don't want to change the name. I mean, the name stays the same for example, I want to modify the age, qualification, ID number or something else but I want to save it without the duplication happening. If this data is repeated, I want to send me a message that this number already exists Also regarding the name, in the event that I modified it and there was one before with the same name, I want to send me a message, because this name already exists Summary, my dear teacher I already have the data, and I want to enter from the edit button, just adjust the existing data, and there are some data that I don't want to duplicate for more than one person For example, name, personal card number and mobile phone number. I don't want it to be repeated at all This means that if you modify one of these data and there was no such data before, that is, it is new data and there will be no duplication. I would like to accept its modification, and if there was the same modification before, it means that this name, card number or mobile phone number will be repeated. I don't want him to accept his modification and send me the message that this data is already there I hope you understood its meaning Thank you very much
Dear teacher I have a problem with duplicating the data from the data modification button. I mean, when I modify the data of some of the employees I have with data I already have, in this case the modification is done and saved, and the duplication occurs. For example I have data kept in the name of / Muhammad Ali Ahmed Saleh And also data for a second employee in the name of / Qusay Ali Ahmed Saleh OK I entered to inquire about one of these names, let it be Qusay, for example I changed the first word in his name instead of Qusai, changed it to Muhammad and left the rest of his name as it was. It means his name Muhammad Ali Ahmed Saleh OK I clicked the Modify button, modified and saved I went to the sheet and saw that I had two names repeated Here's the problem I don't want two names to be repeated Please solve this difficult and complex problem for me 😘😘 Of course, this problem is in the data modification button Not in the save data button
Thanks allot. Exactly what I wanted. Didn't hear a word but got what I wanted.
super
THANKS A LOT FOR THIS TUTORIAL
Would love a link to this tutorial file. Thank You
Thanks. It is very helpful. Would it also be possible, if a user enter the same Reference Nr and message should display, "Reference Nr" exists, do you want to save the Reference Nr as a new Refeference nr. If the User enter the yes option the new record should be save in the database. Could you please show this senario. User should not enter the new reference nr; the new Reference nr should be incremented automatically after clicking the yes option. Hopfeully i explained correctly. Thanks in advance
how to do overwrite data entry in vba excel????
i need full video or all video pls
I used the no-repeat code, but it didn't work. Every time I try to edit and save it, it sends me a message. This name has existed before and cannot be repeated. Of course, I do not want to add, but I am trying to modify some data
Because when I try to edit, I don't want to change the name. I mean, the name stays the same for example, I want to modify the age, qualification, ID number or something else but I want to save it without the duplication happening. If this data is repeated, I want to send me a message that this number already exists
Also regarding the name, in the event that I modified it and there was one before with the same name, I want to send me a message, because this name already exists
Summary, my dear teacher
I already have the data, and I want to enter from the edit button, just adjust the existing data, and there are some data that I don't want to duplicate for more than one person
For example, name, personal card number and mobile phone number. I don't want it to be repeated at all
This means that if you modify one of these data and there was no such data before, that is, it is new data and there will be no duplication. I would like to accept its modification, and if there was the same modification before, it means that this name, card number or mobile phone number will be repeated. I don't want him to accept his modification and send me the message that this data is already there
I hope you understood its meaning
Thank you very much
Ok
Please avoid background noise my dear friend.
How about if i have 2 values...
For example Range ("A:B")
Dear teacher
I have a problem with duplicating the data from the data modification button. I mean, when I modify the data of some of the employees I have with data I already have, in this case the modification is done and saved, and the duplication occurs.
For example
I have data kept in the name of / Muhammad Ali Ahmed Saleh
And also data for a second employee in the name of / Qusay Ali Ahmed Saleh
OK
I entered to inquire about one of these names, let it be Qusay, for example
I changed the first word in his name instead of Qusai, changed it to Muhammad and left the rest of his name as it was.
It means his name
Muhammad Ali Ahmed Saleh
OK
I clicked the Modify button, modified and saved
I went to the sheet and saw that I had two names repeated
Here's the problem
I don't want two names to be repeated
Please solve this difficult and complex problem for me 😘😘
Of course, this problem is in the data modification button
Not in the save data button
Sir
Pl send this file for practice
drive.google.com/file/d/1d0FYJrGl-geNKOZsD0m883bU-lz_n5YF/view?usp=sharing
Practice ke liye yah wali file send kijiye
drive.google.com/file/d/1d0FYJrGl-geNKOZsD0m883bU-lz_n5YF/view?usp=sharing
Thank You for subscribing my channel