Hi all

I have a bit of a weird question for you. I am using Dtpicker on a userform to submit a dates along with other info to a spreadsheet. However, sometimes there is no date so it is just left blank, this doesn't cause an issue when submitting. However, the form I have created also retrieves data on the spreadsheet, so I can update any submission.

The problem I have is when I attempt to do this with Dtpicker, if the date section is blank then I get an error message. The retrieval code is below. R7 and R8 are Dtpicker ones. Can anyone help? Thanks in anticipation of any help with this.

Please Login or Register  to view this content.