I am really good at vba, but many times I wish I had a few other tools in my MS Office tool-belt. (Maybe like dot Net?) So today's question is how to create a very simple Excel function is some language other than VBA.
The other day I was googling an unrelated topic when I ran across the following code snippet that is a perfect starting point for my quest.
That post said:
First, create the following excel function.
public static object IsMultipleOfThree([ExcelArgument(AllowReference =true)] object input)
if (input is ExcelReference er &&
er.GetValue() is double d)
return d % 3 == 0;
.... other text from that post is of no interest to today's question.
What language is post using, and how hard would it be for me to implement that exact function and nothing else in that same language?
I am presuming I might need to buy some software, but that is of no importance. But, if there are 20 steps that will take me 5 hours to perform, will probably not bother.