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
 

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 2
Option Private Module 3
arguments not working with function 5
Scope of private function 1
How to call a private sub() in another module 4
Functions - visibility 3
Option Private Module (for Object Modules) 5
Scope of private function in VBA Module 2

Back
Top