UserForm VBA excel. Saving data depending on the parameters
gogazapr
TrowaD
- Posts
- 3
- Registration date
- Friday June 18, 2021
- Status
- Member
- Last seen
- February 7, 2022
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
1 reply
TrowaD
Feb 8, 2022 at 11:54 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 8, 2022 at 11:54 AM
Hi Gogazapr,
When you use Textbox1 to input the year and want the value from Textbox2 to go to cell A1 of the sheet entered in Textbox1, the code line for the command button would be:
Best regards,
Trowa
When you use Textbox1 to input the year and want the value from Textbox2 to go to cell A1 of the sheet entered in Textbox1, the code line for the command button would be:
Sheets(TextBox1.Value).Range("A1").Value = TextBox2.Value
Best regards,
Trowa