Excel VBA: How to reference sheet names that are based on dates

Is This what you mean

Please Login or Register  to view this content.

So with the user form I have it so that values are entered into various text boxes and then a confirm button is clicked. Within the code for that confirm button I want the various values entered into the text boxes to be printed onto a sheet that corresponds with the current date. I only know how to reference explicitly sheets:

for example lets pretend one of the text boxes on the user form is named txtOne and the value entered in by the user was "hello" upon clicking confirm:

Range("Sheet1!A1").Cells(1, 1) = txtOne

I expect based on the line of code above for "hello" to be printed in cell A1 of the sheet titled "Sheet 1". This all works for me but however I don't want to explicitly reference every single possible date for sheet names.

Range("15-08-2019!A1").Cells(1, 1) = txtOne
Range("16-08-2019!A1").Cells(1, 1) = txtOne
Range("17-08-2019!A1").Cells(1, 1) = txtOne .....etc

Is there a way, to within that line reference it so that the code searches for the sheet that has the same name as the current date: i.e if the date is the 20th August it'll print the value from txtOne into cell A1 of the sheet named "20-08-2019"

Thanks

Thank you very much!! I'll start integrating it into the user form code.

Have a look at this way of addressing your ranges.

Workbook attached

Please Login or Register  to view this content.