@Risk: Adding Outputs from VBA

Your macro code should insert a RiskOutput( ) function at the beginning of the formula in the worksheet cell, using normal Excel VBA methods such as the Formula member. For example, suppose you have a cell containing this formula: =NPV(.1,G1:G10) To make it an output, change the formula to =RiskOutput( )+NPV(.1,G1:G10) Optional arguments to the RiskOutput( ) function let you designate a name for the output, or specify multiple outputs as an output range. For details on usage, please see the RiskOutput topic in the @RISK for Excel Help file or in the Reference section of the @RISK for Excel user manual. Note: There is no longer a dedicated VBA method to designate an @RISK output.

nov. 25, 2025
Knowledge

Titre

Answer

Applies to: @RISK 5.x–7.x

Adding Outputs from VBA

Your macro code should insert a RiskOutput( ) function at the beginning of the formula in the worksheet cell, using normal Excel VBA methods such as the Formula member.

For example, suppose you have a cell containing this formula:

=NPV(.1,G1:G10)

To make it an output, change the formula to

=RiskOutput( )+NPV(.1,G1:G10)

Optional arguments to the RiskOutput( ) function let you designate a name for the output, or specify multiple outputs as an output range.

For details on usage, please see the RiskOutput topic in the @RISK for Excel Help file or in the Reference section of the @RISK for Excel user manual.

Note: There is no longer a dedicated VBA method to designate an @RISK output.

Nom de l'URL

at-risk-adding-outputs-from-vba

@Risk: Adding Outputs from VBA

Informations