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.
Bookmarks