View Single Post
Old January 31st, 2005, 08:12 AM
JpJoe JpJoe is offline
Friend of Wrox
Join Date: Jan 2005
Location: , , United Kingdom.
Posts: 100
Thanks: 0
Thanked 0 Times in 0 Posts

I dont think you can call functions from the macro window. you can only call them from code or expressions. I might be wrong though.

What i would do is create a sub that calls the function -

Sub CallTransposerFunction() 'No arguments
    Dim strSrc As String
    Dim strTgt As String
    'Populate the variables required
    StrSrc = "Some String"
    strTgt = "Another String"
    'And call the function
    Call Transposer (strSrc, strTgt)
End Sub

Note - Dont use arguments in the sub or else it wont appear. you need to Populate the variables inside the sub and pass the lot to your function.

Hope this helps!!