This example runs a simulation of 1000 trials and then pastes the standard deviation of the forecast in B7 into cell M6.
In a macro, you can enter:
CB.Simulation 1000 Range("M6").Value = CB.GetForeStat(Range("B7"), cbFstStdDev)