Copy Bot Killer Notes tests. ByVal ByRef Application.Run.OnTime Multiple Variable Arguments ByRef ByVal

**DocAElstein** · 06-08-2016, 02:24 PM

This is the sort of output seen in the Immediate window, which is showing the right hand side of the Application.OnTime second argument string

Code:

Rem 1
This workbook module, single arrgument
!'Modul1.UnderMainMacro 465'
!'Modul1.UnderMainMacro "465"'

UverFile module, single argument
!'Modul1.MacroInUverFile 465'
!'Modul1.MacroInUverFile "465"'

Thisworkbook module, multiple arguments
!'Modul1.UnderUnderMainMacro 465, 25'
!'Modul1.UnderUnderMainMacro 465, "25"' 

UverFile module, multiple argument
!'Modul1.MacroUnderMacroInUverFile 465, 25'
!'Modul1.MacroUndermacroInUverFile 465, "25"'

mess about with argument positions
!'Modul1.UnderUnderMainMacro      465   ,     "25"          '

This workbook first worksheet code module, single arrgument
!'Tabelle1.InLisWbFirstWcCodeModule 465'
!'Tabelle1.InLisWbFirstWcCodeModule "465"'

UverFile  first worksheet code module, single arrgument
!'Tabelle1.InUverFileFirstWsCodeModule 465'
!'Tabelle1.InUverFileFirstWsCodeModule "465"'

This workbook first worksheet code module, multiple arguments
!'Tabelle1.InLisWbFirstWcCodeModuleMultipleArguments 465      ,  "25"         '
!'Tabelle1.InLisWbFirstWcCodeModuleMultipleArguments      "465"   ,   25    '

UverFile  first worksheet code module, Multiple  arrgument
!'Tabelle1.InUverFileFirstWsCodeModuleMultipleArguments   465   ,    "25"       '
!'Tabelle1.InUverFileFirstWsCodeModuleMultipleArguments "465"   ,    "25"  '

Doubles do not have to be in quotes either  ' This workbook module, double argument arrgument
!'Modul1.DoubleCheck 465.5   , "25.4"    '

Rem 2 Variables
'2a)  "Pseudo"  variables use
!'Modul1.DoubleCheck  "465.42"  ,   "25.4"  '
!'Modul1.DoubleCheck  "465.42"  ,   25.4  '

'2b) Real varable use
!'Modul1.DoubleCheck  Modul1.Pbic_Arg1  ,   Pbic_Arg2  '
!'Modul1.DoubleCheck Modul1.Pbic_Arg1, Pbic_Arg2'
!'Modul1.DoubleCheck module2.Pbic_Arg1, Pbic_Arg2'



Rem 3     ByRef Check
25.4



Rem 3     ByRef Check
25.4



Rem 3     ByRef Check
999.99

Thread: Copy Bot Killer Notes tests. ByVal ByRef Application.Run.OnTime Multiple Variable Arguments ByRef ByVal

Thread Tools

Display

Threaded View

Similar Threads

Some Date Notes and Tests

Table Tests. And Thread Copy Tests No Reply needed

Conditionally Manage Multiple Items In Worksheet_Change(ByVal Target As Range) Event

Excel Workbook ReOpening After Closing With Application.OnTime

Bookmarks

Bookmarks

Posting Permissions