Show the code that you have for the function: AreYouSure

There is an argument between the Prompt and the caption.

Examples:
If Not AreYouSure("Delete " & Description & "?", , "Delete") Then Exit Sub

or

If Not AreYouSure("Delete " & Description & "?", vbOKOnly, "Delete") Then Exit Sub

I stand corrected. Just noticed you are using the AreYouSure() function.

Make sure Description has a value. If it's NULL it will throw an error. You'll need:

AreYouSure("Delete " & Nz(Description,"") ...

I'll address this in the next video.

But then again, on second thought, description should never be null. We should probably make sure that it's required.

Now it's rejecting "AreYouSure"  with the same compile error?

Do you have the AreYouSure function in a public module?

YES I DO AS FOLLOWS.
Public Function AreYouSure() As Boolean
    If MsgBox("AreYouSure?", vbYesNoCancel + vbQuestion + vbDefaultButton2, "Confirm") = vbYes Then
        AreYouSure = True
    Else
        AreYouSure = False
   End If
End Function

I don't see any parameters to pass the description into.  You might checkout the Create Function video.

Hi Normand,

Your "Are You Sure" function doesn't accept any parameters as it is written. It is just the vanilla version. Before Richard added the "Prompt" and "Title" optional parameters.

That's why it is giving you invalid # of arguments.

If you review the link to the Are You Sure? TechHelp Video Richard gave above, you'll see that at around 7 minutes, he added those two optional parameters.

I think that will resolve this error.

Thank you all for the replies. The last reply from Donald fix the problem..

Happens to me too. Swe something great in one of the videos and put it in a project but miss the end.

Guess that's why "patience is a virtue", lol.