Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I understand how to pass number and string arguments with OnTime. But
what about object arguments? Can I pass a range object, combobox object, etc.? Here's how I'm passing number and string arguments. How do I pass object arguments? Function tester1() Const NUM_ARG As Long = 5 Const STRING_ARG As String = "String" Debug.Print "tester1: " & NUM_ARG & ", " & STRING_ARG & ", " & Now Application.OnTime Now + 0.0000001, "'tester2 " & NUM_ARG & ", """ & STRING_ARG & """'" End Function Function tester2(NUM_ARG, STRING_ARG) Debug.Print "tester2: " & NUM_ARG & ", " & STRING_ARG & ", " & Now Debug.Print End Function Thanks, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to pass variables as arguments of a function | Excel Worksheet Functions | |||
How to pass arguments to vlookup in VBA | Excel Programming | |||
Application.OnTime -- Unable to Pass Macro with Numeric Parameter | Excel Programming | |||
Run/execute VBS and pass arguments | Excel Programming | |||
How to pass arguments from ThisWorkbook to a UserForm | Excel Programming |