vbYesNo as a Function

[nightcrawler23]

Just as we can have a msgbox return the values vbyes, vbno, vbcancel how can i make function return this.

Below is a code i wrote. but this gives me an error "Argument not optional" and the function name is highlighted.

Sub sheetExist(prop As String)
Dim sh As Worksheet

For Each sh In ThisWorkbook.Worksheets
    If sh.Name = sh.CodeName & "_" & prop Then
        sheetExist= MsgBox("sheetExist", _
            vbYesNoCancel & vbCritical, "Property Match")
        Exit For
    End If
Next sh

End Sub

 

[RichardMGreen]

Try renaming it from a sub to a function.
It looks like it's trying to call itself without the parameter.