jorge49's blog
Programming the output format within a UDF
Submitted by jorge49 on 29 October, 2012 - 16:09I 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:
»
- 4 comments
- Read more
- 3632 reads
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago