Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
Please examine the following statement,
Application.OnTime Now + TimeValue("00:00:01"), "CentrAcroSelection" How could any arguments (as required) be assigned accordingly ? Please share your experience. Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
Stringtime = "00:00:01"
STime = TimeValue(Stringtime) MyProcedure = "CentrAcroSelection" Application.OnTime Now + STime, MyProcedure " wrote: Please examine the following statement, Application.OnTime Now + TimeValue("00:00:01"), "CentrAcroSelection" How could any arguments (as required) be assigned accordingly ? Please share your experience. Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
Joel, Esq.,
Thank you for responding to the query. Would like to have called the Sub as if bearing the effects of, Call CentrAcroSelection(TitleWrap) Needless to say, TitleWrap is an argument to be processed by the Sub, CentrAcroSelection. However, the syntax of OnTime method (shown above) prevents the assignment of TitleWrap to CentrAcroSelection as it is. Please extend a helping hand. Regards. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
Use a public variable to pass the parameter
Public MyParameter As String Sub test() MyParameter = "abc" Application.OnTime Now + TimeValue("00:00:5"), "my_Procedure" End Sub Sub my_Procedure() MsgBox (MyParameter) End Sub " wrote: Joel, Esq., Thank you for responding to the query. Would like to have called the Sub as if bearing the effects of, Call CentrAcroSelection(TitleWrap) Needless to say, TitleWrap is an argument to be processed by the Sub, CentrAcroSelection. However, the syntax of OnTime method (shown above) prevents the assignment of TitleWrap to CentrAcroSelection as it is. Please extend a helping hand. Regards. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
Joel, Esq.,
Thank you again. "Use a Public Variable" ; that's a viable means indeed. There appears to be no alternative means (good try aside, but in vain) to daisy-chain arguments to the following statement, Application.OnTime Now + TimeValue("00:00:5"), "my_Procedure" & <Daisy- Chain of Arguments Regards. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
You can make the public variable an array like
Public arg(5) as Variant Sub Main() arg(0) = "Hello" arg(1) = "World" arg(2) = "Goodbye" arg(3) = "Joel" arg(4) = 123 Application.OnTime Now + TimeValue("00:00:5"), "my_Procedure" End Sub Sub my_Procedure() 'enter yor code here End Sub The above example is very similar to the way Unix, and C language pass parameters except instead of make the vaiable Publid the variable are pushed onto a calling stack. " wrote: Joel, Esq., Thank you again. "Use a Public Variable" ; that's a viable means indeed. There appears to be no alternative means (good try aside, but in vain) to daisy-chain arguments to the following statement, Application.OnTime Now + TimeValue("00:00:5"), "my_Procedure" & <Daisy- Chain of Arguments Regards. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel To Call Sub and Assign Arguments
Joel, Esq.,
Thank you again. After some search, found the following :- http://groups.google.com/group/micro...b5a31754f7b7e2 Could be useful reference next. Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
call a macro with arguments in a Command Button | Excel Programming | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Does excel acept arguments | Excel Worksheet Functions | |||
If statement that contains 6+ arguments in excel | Excel Worksheet Functions | |||
call a sub with arguments from Worksheet_FollowHyperlink event | Excel Programming |