Hi Winon,

Thanks so much for your help. Unfortunately, that doesn't seem to have worked. It's stopped throwing an error when BNCheckButton is clicked, but the code isn't doing what it should:

-When BNCheckButton is clicked, it's not filling the form with pre-existing entries
-When UpdateExistingButton is clicked, it's not overwriting the text in that row with what has been filled in on the userform
-When OKNext is clicked, it saves the data to the spreadsheet, but still shows the 1004 error
-When OKClose is clicked, it saves the data to the spreadsheet, but still shows the 1004 error.

But thanks for getting rid of the error on BNCheckButton! What's the next step?

Thanks!