Now that we have our web service, lets get started by writing a managed UDF that uses the web method “GetColumnValue”. In fact, the UDF will mirror this web method and make it so we can use it in Excel formulas. First, add a new C# or VB class library project to your solution using File > Add > New Project. Name the project BugAddIn
Original post:
3. VSTO Bug Tracker : A UDF