User defined function excel not updating

Rated 4.37/5 based on 892 customer reviews

We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).I looked around a bit and saw application.volatile is a solution to this problem.I tried adding it (as you can see above) but nothing changes Does the application.volatile need to go somewhere else?

the code is below Function Sum Color(r Color As Range, r Sum Range As Range)'Written by Ozgrid Business Applications'

Don't worry, you're not lost at all, all you need is to create the function yourself.

Excel allows you to create custom functions using VBA, called "User Defined Functions" (UDFs) that can be used the same way you would use SUM() or other built-in Excel functions.

A UDF is simply a function that you create yourself with VBA. Use the function (Appears in the Paste Function dialog box (press Shift F3), under the "User Defined" category).

This blog will help you get started with UDFs and show a couple of examples. If you want to use a UDF in more than one workbook, you can save your functions in your own custom add-in.

Leave a Reply