Use UDF In Conditional Formatting
in [Programming]
|
From: Faraz Ahmed Qureshi on 30 Apr 2010 08:16 Any guidance as to how to have a UDF in an addin be declared/registered etc. so as to be used like all other usual/normal functions? like be autocompleted upon partial entry, arguments be displayed in the supertip and be capable to be used in the Conditional Formatting and other features? -- Thanx in advance & Best Regards, Faraz!
From: Jacob Skaria on 30 Apr 2010 08:32 Hi Faraz Check out the below by Jan Karel Pieterse http://www.jkp-ads.com/articles/RegisterUDF01.asp -- Jacob (MVP - Excel) "Faraz Ahmed Qureshi" wrote: > Any guidance as to how to have a UDF in an addin be declared/registered etc. > so as to be used like all other usual/normal functions? like be autocompleted > upon partial entry, arguments be displayed in the supertip and be capable to > be used in the Conditional Formatting and other features? > > -- > Thanx in advance & Best Regards, > > Faraz!
From: Peter T on 30 Apr 2010 08:38 In 97-2003, in the CF dialog change Cell Value Is to Formula Is and enter a formula that evaluates to True/False. In 2007+, in CF rules, click on "Use a Formula to determine which cells to Format" Enter your UDF in the normal way in the CF formula Experiment with Relative & Absolute references, there are significant differences in the way they work particularly when it comes to copying cells with CFs. Regards, Peter T "Faraz Ahmed Qureshi" <FarazAhmedQureshi(a)discussions.microsoft.com> wrote in message news:DE737BF8-1BF3-4C21-8897-F4F24396045B(a)microsoft.com... > Any guidance as to how to have a UDF in an addin be declared/registered > etc. > so as to be used like all other usual/normal functions? like be > autocompleted > upon partial entry, arguments be displayed in the supertip and be capable > to > be used in the Conditional Formatting and other features? > > -- > Thanx in advance & Best Regards, > > Faraz!
|
Pages: 1 Prev: Getting Data Validation to execute when using Paste Special... Next: Macro Help |