Data not adding to the next row

[hybadtouba]

Hello everyone,
I am looking for some help in adding the data to row tow and consecutively adding the data to the next row and so on. But my code only add the data on the header row(1st row) and doesn't add to the next row but will replace the previously added to the 1st row if new data is added. Could someone help me fix this issue please? I have pasted my code here and images on the userform and issues. I was not able to upload my excel file and if any tip to how to upload it please let me know.

Thank you!

Best,

Hyacinthe Badiane

Please Login or Register  to view this content.

End Sub

Useform.PNG

data adding to 1st row only.PNG

sheets header.PNG

[torachan]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[hybadtouba]

Thank you very much for pointing out the mistake. I just corrected it and save the changes.

[torachan]

I have made alterations to your code as attached.
You had not searched for the last row.
Also in all the sheets there was/is spurious data around row 4000 ???
The lastrow counter now just looks at column A.
I have only cleared the first sheet, you will have to clear the others.
Also you have a column formatted % this puts a column of data in place - remove the formatting
If you are creating a pseudo database refrain from any entry other than through code.
As you progress I would urge you to explore using tables - far more self maintaining and easier to manipulate data.
Also consider populating your comboboxes from arrays via separate tables on a validation sheet.
This makes the comboboxes far easier to expand rather than constantly altering the hard coded additem.
Any further queries post back on this site.
torachan

a couple more points.
I have iterated out your duplicate checking code - it was not working - you need to look again as how you want to check.
Also the relationship of combobox data does not seem to align with the subject headings on the sheet - cell references need looking at.

[hybadtouba]

Thank so much! I can't thank you enough for the help. my forms work now and i am ready to lunch them. Thank you indefinitely, you are a life saver!
Have a wonderful day and Be blessed!

best,

Hyacinthe Badiane