I have a question about submit without a Button on a form.

[sf49ers164480]

How I setup submit data without a button

[Fluff13]

What's wrong with using a button?
Without one, how would you determine when to submit the data?

[sf49ers164480]

one my friend ask in anyway without using a button to submit data to sheet

[Gregb11]

you're referring to a User Form? What would you like to do?

[sf49ers164480]

yes referring to userform 1 to submit data without pressing a button somthing like you get to textbox4 it send it to worksheets

[Gregb11]

you get to textbox4 it send it to worksheets

Not sure what this means. Do you mean when the user puts their cursor in text box 4 that the form should submit?

[sf49ers164480]

did you put some data in all 4 boxes last will you put C or H or F in type

[Gregb11]

Sorry, I don't know what you are saying. Maybe someone else can interpret.

[Fluff13]

Whatever code you would put in a button to add the data to a sheet, simply put in a textbox exit event instead.
Other than that I cannot help, as I simply don't understand what you are saying.