tag:blogger.com,1999:blog-28492262.post3848771013492050493..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: How to Return Multiple Values from a VBA FunctionUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-28492262.post-70999774588404317762012-03-21T04:20:56.738-07:002012-03-21T04:20:56.738-07:00Set osoap = CreateObject("MSSOAP.SoapClient&q...Set osoap = CreateObject("MSSOAP.SoapClient")<br />osoap.ClientProperty("ServerHTTPRequest") = True<br />osoap.mssoapinit ("http://192.168.2.30:5050/Selling/soap/description?WSDL")<br />result = osoap.get_customer_debit_balance(CUSTOMERID)'this function return type is float and it is working fine<br />Dim result1 As object<br />result1 = osoap.get_customer_balance(1010) 'this function return type is CustomerBalance class object<br />MsgBox result1<br /><br />I am running this code and getting invalid procedure or function call error message<br /><br />when I am using PHP with SOAP and this function returning array but in VB i am getting error. <br /><br />please help me to fix up this problem and explain me how to get multiple values from a function using VB.haiderhttps://www.blogger.com/profile/16089979698273067424noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-46590992378210536012011-06-09T07:09:01.849-07:002011-06-09T07:09:01.849-07:00To make it perform as a function, change it as fol...To make it perform as a function, change it as follows:F<br />unction ChangeLengthAndBreadth(ByRef Length As Double, ByRef Width As Double) As ""Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-59129681542350848172011-05-31T06:36:11.229-07:002011-05-31T06:36:11.229-07:00Good Call, it simply changes multiple values. The ...Good Call, it simply changes multiple values. The second "Function" is not really a function but a Sub.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-88974955455416930252008-11-26T04:13:00.000-08:002008-11-26T04:13:00.000-08:00Does it *return* multiple values, or simply *chang...Does it *return* multiple values, or simply *change* multiple values?JPhttps://www.blogger.com/profile/06464959334594594876noreply@blogger.com