Pedro Mendes
New Member
- Joined
- Jun 8, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
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
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