troubleshooting Question

How to create a simple UDF without using VBA?

Avatar of Robert Berke
Robert BerkeFlag for United States of America asked on
SoftwareMicrosoft OfficeVBAMicrosoft Excel
14 Comments1 Solution198 ViewsLast Modified:
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.

        [ExcelFunction]
        public static object IsMultipleOfThree([ExcelArgument(AllowReference =true)] object input)
        {
            if (input is ExcelReference er &&
                er.GetValue() is double d)
            {
                return d % 3 == 0;
            }
            return false;
        }
.... 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.
ASKER CERTIFIED SOLUTION
NorieSenior Associate
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros