Need some help.
Trying to put this in my Function.
Optional blnCaseSensitive = False As Boolean
I want so if the user doesn't put a value for blnCaseSensitive when they are calling the function, it will automatically be false.
Printable View
Need some help.
Trying to put this in my Function.
Optional blnCaseSensitive = False As Boolean
I want so if the user doesn't put a value for blnCaseSensitive when they are calling the function, it will automatically be false.
Here is an example
Code:Option Explicit
Private Sub Form_Load()
MsgBox SomeFunc
MsgBox SomeFunc(True)
End Sub
Private Function SomeFunc(Optional blnCaseSensitive As Boolean = False) As String
If blnCaseSensitive = False Then
SomeFunc = "Not Passed"
Else
SomeFunc = "Passed"
End If
End Function
Thanks Rob.