Previous Topic Next Topic

UserForm VBA excel. Saving data depending on the parameters

Closed
gogazapr Posts 3 Registration date Friday 18 June 2021 Status Member Last seen 7 February 2022 - 7 Feb 2022 à 01:44
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 8 Feb 2022 à 11:54
Hello,

I created a UserForm through Excel VBA with the data text input which contains dates (ex. 2015,2016 etc.) I need this data to be put into different worksheets upon saving depending on the input year. For example data with a 2015 year needs to go to a designated Sheet 2015, data with 2016 input needs to go into a separate sheet etc.
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
8 Feb 2022 à 11:54
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: 
Sheets(TextBox1.Value).Range("A1").Value = TextBox2.Value


Best regards,
Trowa

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response
VBA Find function
francis-abraham -
ac3mark -

1 response