UserForm Autosave

[Pedro Mendes]

Hello all,

I am quite new to this VBA world and still trying to figure out a lot of things.
I have been searching, but didn't manage to find what I am looking for. So as the subject indicates, I am trying to figure out if there is a way to autosave the input data from a textbox to the spreadsheet without the need of click a save button.

For example lets say that i have a UserForm with 1 TextBox.
And on that TextBox i will input the number 1.
is there a routine that can be coded so that "1" in the TextBox be autosaved to sheet1 cell A1 without any input (click save button for example) from the user?

Thank you all, and wish you a wonderful day.

Regards,
Pedro Mendes

 

[mumps]

You can use something like this:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Sheet1.Range("A1") = TextBox1.Value
End Sub

You enter a value in TextBox1 and press the RETURN key. This will only work if your userform contains more than one texbox or other object.

 

[Pedro Mendes]

Hi mumps,
It works perfect.
Thank you for all the help.

 

[mumps]

You are very welcome.