Hello-I'd sure appreciate any and all help regarding the following problem I'm having. I have a userform that has multiple types of data entry (i.e. combo boxes, text boxes, etc). Upon the user clicking on the "enter" button, which is named "CommandButton1, the data will be placed in the next available line/row and placed in the appropriate columns,etc. The problem I am experiencing is that sometimes the persons entering data accidentally double click the "enter button" or sometimes get distracted and then re-strikes the "enter button" forgetting if they had done so prior and my worksheet is getting multiple entries of duplicate data. I have tried to search this site for prior code that might help in my case without luck. I'm not at all knowledgeable about vba coding and can struggle through some coding I've seen others put together and the following is my attempt to do so; without success. Any assistance would be greatly appreciated!
Bookmarks