Why is there an error when passing parameters?

nymphetamine

Private Sub loopMonthRow (fst_date_mm, fst_date_dd, last_date_mm, last_date_dd As String, row_no As Integer)
loopToFstMonthOrDate fst_date_mm&STR_MONTH_NM, INT_ROW_MONTH
loopToFstMonthOrDate fst_date_dd, INT_ROW_DATE

End Sub

Private Sub loopToFstMonthOrDate (content As String, row As Integer)
. . .
End Sub

When I execute loopMonthRow this method always reports an error
loopToFstMonthOrDate fst_date_dd, INT_ROW_DATE
Fst_date_dd parameter in "BYREF parameter type does not match", but when I change to
loopToFstMonthOrDate fst_date_dd&"", will be correct after INT_ROW_DATE. This is the reason for the company. What should we do?

w9900403

The parameter types in loopToFstMonthOrDate(content As String, row As Integer) are explicitly declared if
Set loopMonthRow(fst_date_mm, fst_date_dd, last_date_mm, last_date_dd As String, row_no As Integer)
The parameters in are also explicitly declared, and have the same value as the parameter type passed when calling loopToFstMonthOrDate. fst_date_dd&"" is equivalent to forcibly converting fst_date_dd to a string type, which is the same as the parameter type in loopToFstMonthOrDate, so no error will be reported.

qinshengo

It is recommended that the host should display the specified type when defining variables, otherwise it is easy to make mistakes

nymphetamine

How to specify the type of the variable explicitly or implicitly when defining a variable

nymphetamine

"in case
LoopMonthRow(fst_date_mm, fst_date_dd, last_date_mm, last_date_dd As String, row_no As Integer)
The parameters in are also explicitly declared,"
Isn't my parameter here explicitly declared?

qinshengo

I don't know what type of variable is fst_date_mm

siyonggang

"in case
LoopMonthRow(fst_date_mm, fst_date_dd, last_date_mm, last_date_dd As String, row_no As Integer)
The parameters in are also explicitly declared,"
Isn't my parameter here explicitly declared?

What is the data type of fst_data_mm, fst_date_dd, last_date_mm?