Using A Specified Date to Select a Cell and enter a value from a text box in vba

Hi,

I am new to this forum and have only recently returned to utilizing VBA to create Excel Applications.

I am having a challenge getting a user form to work.

I have a spreadsheet that is organized with dates across the top.

Below that there are cells to make data entries and then other cells to make calculations.

I have created a form that has a Date Value Seclector and a text box.

I need code that will input the value in the text box into the cell that is directly below the date that has been selected in the date selector.

Please help, this seems like it should be simple, but I can't seem to figure it out.

Would you attach your workbook?

Take a look at the attached workbook and see if it does what you need.

You're welcome. If you need to access different cells, the range in the code can be adjusted accordingly.

Good Luck!