I can't find this on the web.....how do you do this? Is there a special syntax or something?
[VBA]
Sub test(Str As String)
Debug.Print Str
End Sub


Sub Testme()
Dim xl As Excel.Application
Dim Str As String

Str = "hey"
xl.OnTime Now + TimeValue("00:00:01"), "test(Str)"
End Sub[/VBA]
But I'm getting an error with this.......any suggestions? Is this doable?