Input Form to Get Data and Store it in Another Tab in Excel

0

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 Excel
Answer
Discuss

Answers

0
Selected Answer

Hi 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
Discuss

Discussion

That's great! 
many thanks

Tony
Tony_Y (rep: 2) Jun 4, '20 at 8:58 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login