Generating fast normally distributed random numbers efficiently in Excel VBA

I've been looking for a fast and reliable way of generating normally distributed random numbers.

The most popular approach seems to be to use the Excel worksheet function Norm_Inv together with a random number, but this is quite slow because of the need to go back and forward between Excel and VBA.

I'm sharing my solution below, but if there is a better one, I'd love to know it.