web service call from user defined function

hi guys
i am able to call web service from macro using mssaop library.
But in case of user defined functions i am unable to create the object of SoapClient hence unable to call web service.
Error says: User defined types are not allowed in user defined functions.
could u plzz suggest the way how we can call web service from the userdefined functions.

Sometimes there are ways to break the rules. In the case of a function that is called from within a cell, I have never found a way to break the rules.

What you can do, instead, is use a Worksheet_Change Event macro. Have it ignore changes in any cells except the ones you want to have this functionality. Then, when the user makes a change, this triggers your VBA routine that makes the web call.