Writing data to certain line from a textbox based on the value

[kevinc1973]

Hello everyone,
I have a spreadsheet that the rows are labeled 1-31 and data gets entered into it every night at midnight and then the sheet gets saved at the end of each month and a new is started. I want to make a user form and have text box 1 automatically have today's date generated when opened ( i am good with doing this so far). When i add data I want it to go to that line that matches the date. for example textbox 1 has a date of 6/15/2019 then the userform data will write to line 15 (lets say 15 is actually row 18). If someone forgets to enter data on night it will skip that line and make it easier to fix sheet at end of month.
Thanks for any input
Kevin

 

[Snakehips]

@kevinc1973

Assuming your data to be the text of Textbox2 and the receiving column to be C (edit to suit) then, at the point in your code where you wish to commit the data, along the lines of.....

ActiveSheet.Range("C" & Day(Now) + 3) = TextBox2.Text

Hope that helps.

 

[kevinc1973]

Snakehips,
Thank you for the code I will try it and let you know how it works out.