Hello,
In my form on the submit click code, I want the user to be able to enter the date in the textbox for the corresponding cells, then comments in their corresponding cells.
I was not able to upload the form or code to go with it due to size limits, so I have attached them both. Any assistance is appreciated
If anyone has a better way then a textbox for dates, I am all ears.
Code for Date that is now working
'If Me.CS1.Value Then .Range("D11").dsDate = DateSerial("01/01/2020")
Code for textbox comments is not working
If Me.T1.Value Then .Range("D12").Value = T1.Value
If Me.T2.Value Then .Range("F12").Value = T2.Value
If Me.T3.Value Then .Range("H12").Value = T3.Value
If Me.T4.Value Then .Range("J12").Value = T4.Value
If Me.T5.Value Then .Range("L12").Value = T5.Value
form.PNG
Excel.PNG
Bookmarks