ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Improve method of calling a private function in a private module (https://www.excelbanter.com/excel-programming/410257-improve-method-calling-private-function-private-module.html)

XP

Improve method of calling a private function in a private module
 
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.

Rick Rothstein \(MVP - VB\)[_1851_]

Improve method of calling a private function in a private module
 
You can combine all those individual concatenations into single string
value...

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

Rick


"XP" wrote in message
...
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.




All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com