Excel VBA to Excel Sheet data saving Question.

[mr_bhavesh]

The userform of the above code has 3 textbox and 1 commandbutton for submit (data save to sheet),

After clicking submit, data is saved more than once in Range A:C, while data is saved only once in Range D:F and Range G:I, or if any correction is made in the textbox, the saved data is updated.

Is there an error in the code? Or has something gone wrong? help me

 

[Anthony47]

How did you determine that the data is saved more than once in A:C?
If you want to save the textboxes content to the destination cell when their content changes then you need to use the Textbox_Change event, but this will trigger for any change not when the final value has been typed. Or you could use the TextBox_Exit event, that however will trigger only if you move the focus to a different control.
Also, keep in mind that a textbox returns a "text", so maybe it would be better if you use, for example If txt_line.Text = "11" Then '11 as a string