Hi Everybody!
I have been trying to connect the data of the UserForm with an Excel Sheet. I have 2 sheets in my Excel Book, one works fine but the other one does not.
On the 1st sheet the information is well entered but on the second one it appears in row 20, and I want it to appear in row 3
* The Code I wrote is the following:
Abonnement = Worksheets("Archiv").UsedRange.Rows.Count
Abonnement = Abonnement + 1
Worksheets("Archiv").Cells(Abonnement, 2) = Nametbx
Worksheets("Archiv").Cells(Abonnement, 3) = Vnametbx
Worksheets("Archiv").Cells(Abonnement, 4) = Bdaytbx
Worksheets("Archiv").Cells(Abonnement, 5) = emailtbx
Worksheets("Archiv").Cells(Abonnement, 6) = addtbx
Worksheets("Archiv").Cells(Abonnement, 7) = Angebotcmb
Worksheets("Archiv").Cells(Abonnement, 8) = DateTbx
This second Sheet called "Archiv" has to registered all the customer information, and when I make another UserForm, the information of former customers should remain as well and put the new customer information on the row below.
Could anyone help me please?
Thxxxxxxxx :)
|