jorge49's blog

Programming the output format within a UDF

I made a UDF in Excel 2010 which is programmed to give an output in acordance to the value of the transfered parameters, for the best display I need to be able to modify the output format in correspondence with the results, the question is:

Is it possible to include, as a part of the UDF, a code to make a conditional format to display the result in an appropriate format? if so, how can I program it?.

To illustrate the question take this: functionName(A,B,C,D,E)

where A,B,C,D are the parameters for the calculus and E is the format parameter, for example:

Syndicate content