UserForm VBA excel. Saving data depending on the parameters
Closed
gogazapr
Posts
3
Registration date
Friday June 18, 2021
Status
Member
Last seen
February 7, 2022
-
Feb 7, 2022 at 01:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 8, 2022 at 11:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 8, 2022 at 11:54 AM
Related:
- Excel vba
- Number to words in excel without vba - Guide
- How to enable vba in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Vba case like - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Feb 8, 2022 at 11:54 AM
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