![]() |
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. |
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