Improve method of calling a private function in a private module

  • Thread starter Thread starter XP
  • Start date Start date
X

XP

I'm calling a "private" function in another module using "Option Private
Module" and this function takes two arguments. My code functions like so:

Run "InputBoxDate(" & """" & "Arg1" & """" & "," & """" & "Arg2" & """" & ")"

Is there an easier method of doing this without having to supply all the
double quotes?

Thanks in advance.
 
You can combine all those individual concatenations into single string
value...

Run "InputBoxDate(""Arg1"",""Arg2"")"

Rick
 
Back
Top