Hi Cesw,

Try changing:

modCustID(tbStart, tbEnd)

to

modCustID tbStart, tbEnd


---
Regards,
Norman



"cesw" wrote in message
...

I have the following snippet that is getting this compile error

If ckbCustID = True Then
MsgBox ("run Customer / Interdealer Rpt")
modCustID(tbStart, tbEnd)
End If


modCustID is another module in the add-in defined:

Sub modCustID(startDt, endDt)
..
end sub


so can anyone shed some light on why the compiler seems to want an =
after the call?

Thx.


--
cesw
------------------------------------------------------------------------
cesw's Profile:
http://www.excelforum.com/member.php...o&userid=27117
View this thread: http://www.excelforum.com/showthread...hreadid=466361