Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Baffled by calling a private function | Excel Programming | |||
Calling Private Sub/Function | Excel Programming | |||
private variable: same module, other Sub/Function | Excel Programming | |||
Calling a Private Sub | Excel Programming | |||
Call Private Function from ThisWorkbook module | Excel Programming |