Improve method of calling a private function in a private module

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.
 
R

Rick Rothstein \(MVP - VB\)

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

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

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option Private Module 3
Option Private Module 2
arguments not working with function 5
Scope of private function 1
How to call a private sub() in another module 4
Scope of private function in VBA Module 2
When something in module is shown as a macro 3
Error when doing a paste 3

Top