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
Default

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!!

Jp