I have the following code but it is giving me a 'ByRef Type Argument Type Mismatch' error.
Can someone help me locate the error? (range_text is a text box)
private sub borders_cmd_click()
Dim u, v, w, x, y, z As Boolean
{the variable are then given boolean value}
Borders (range_text), u, v, w, x, y, z
End Sub
Sub Borders(rng As Range, a As Boolean, b As Boolean, c As Boolean, d As Boolean, e As Boolean, f As Boolean)
{code}
End Sub
Can someone help me locate the error? (range_text is a text box)
private sub borders_cmd_click()
Dim u, v, w, x, y, z As Boolean
{the variable are then given boolean value}
Borders (range_text), u, v, w, x, y, z
End Sub
Sub Borders(rng As Range, a As Boolean, b As Boolean, c As Boolean, d As Boolean, e As Boolean, f As Boolean)
{code}
End Sub