Excel Custom Functions RRS feed

  • Question

  • I'm creating an app in excel that will pull in external data using a task pane, however I'd also like to give users the ability to use a custom function in a cell to pull the data too.  Ex: in A1 an user could enter "=custfunction("#", "Text")" and it would run.  I've read how to do this in articles like: http://www.dummies.com/how-to/content/how-to-describe-a-custom-excel-2013-function.pageCd-storyboard,pageNum-8.html

    But can these functions become part of the app? And if so, what is the best way to set this up?

    Tuesday, April 9, 2013 3:54 PM