On Sun, 2005-02-20 at 13:53 -0600, Fred Grant wrote: > In XL I could put a formula call in a cell that would pass parameters > to, and return a value from, vb code that I had written. > > Can this be done in calc? If not, will it be in the new release?
<tip author="Jonathon Coombes" subject="Creating Calc Functions" category="Calc"> You can create your own Calc functions for use in spreadsheet formulae simply by creating a macro that accepts the parameters you require. Once the macro is saved and compiled, you can access it as a formula using the function name eg =MACRO_FUNCTION_NAME(Arg1,Arg2). Note that you do need to return a value for this to be useful. </tip> -- OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase - http://mindmeld.cybersite.com.au/ Cybersite Consulting - http://www.cybersite.com.au/ Training4Linux - http://www.training4linux.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
