View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Implement Excel cell function using VSTO

You can just create a Class Library in VS2005, reference it from the
Automation Add-Ins dialog (access this from the XLA Add-Ins dialog), and
then use the function directly from a cell. Neither VBA nor VSTO is
necessary. See "Creating A Function Library In VB.NET" at
http://www.cpearson.com/Excel/Creati...nctionLib.aspx .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Andrew Wiles" wrote in message
...
Hi

Is there any way to implement a user defined function for use in
spreadsheet
cells using VSTO? Is it possible/neccesary to use a vba add-in to make a
call
back into a managed VSTO app?