200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi
i have recently completed the input form to get data and store it in another tab (by Don). I am trying to come up with a Vba so I cannot duplicate a row on my database. To achieve this I have serial numbered by database
Input Form to Get Data and Store it in Another Tab in ExcelHi there, glad you saw the tutorial) I show you how to do this in the Premium Course for the forms, but if you want to do it on your own, just check the column where you will put the data for the new serial number before you put it in there. You can do that using the FIND method for VBA
Sample code from the msdn site:
With Worksheets(1).Range("a1:a500")
Set c = .Find(2, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
' value found - already in list
End If
End With