Byref Argument Type Mismatch

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get the "Byref Argument Type Mismatch" error when I try to pass 2 arguments
from VBA module-1 to module-2 using the below code: When I modify the code
to only accept 1 argument it works but i'd like to pass both.

thanks Alex

module-1
ProjSnap strSelected, SQLText
module-2
Public Sub ProjSnap(strSelected As String, SQLText As String)
 
Alex said:
I get the "Byref Argument Type Mismatch" error when I try to pass 2
arguments from VBA module-1 to module-2 using the below code: When I
modify the code to only accept 1 argument it works but i'd like to
pass both.

thanks Alex

module-1
ProjSnap strSelected, SQLText
module-2
Public Sub ProjSnap(strSelected As String, SQLText As String)
Click to expand...

What are the definitions of strSelected and SQLText?
 
Back
Top