Export (activeX) TextBox Values to multiple Rows

[sfirita]

Hi, everyone

i'm new here, and i'm a beginner in excel/VBA scripting , i have also an average english skill so i'll try my best to be as clear as possible.

i'm a bit confused , cause i want to export the values of 3 textboxes(activeX) into another worksheet and increment the lines (Rows) each time i click the button made for that reason,

i have 2 worksheets : Feuil1, and Feuil3

my actual code only allow me to export the data to a specific Cell and increment it.

what i want is to insert the values of the 3 textboxes as a complete row(line) in the other worksheet.

Here is my code :

Please Login or Register  to view this content.

and thanks in advance for your answers.

NB : i've already did a search, but i only find similar things on userforms and not a simple export from an activeX textboxes into rows

[walruseggman]

Please Login or Register  to view this content.

[bakerman2]

Or

Please Login or Register  to view this content.

[sfirita]

thanks !! bankerman2 and walruseggman !!!!

it does work!!!!

but i noticed a little problem if you can help me with guys...

When I delete the inserted values ​​( not the lines ) and I try again , the insertion is not done from the first row all over again , it continue to put the values depending on the last line inserted (after it, in fact)..

do you have an idea ??