LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Baffled by calling a private function travis[_3_] Excel Programming 5 September 4th 06 04:21 AM
Calling Private Sub/Function AMK4[_36_] Excel Programming 5 February 4th 06 01:47 AM
private variable: same module, other Sub/Function Stefi Excel Programming 4 July 5th 05 09:10 AM
Calling a Private Sub ben Excel Programming 8 December 8th 04 10:18 PM
Call Private Function from ThisWorkbook module Beto[_3_] Excel Programming 3 February 25th 04 01:36 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"