How do I draw random numbers from a Weibull distribution with known parameters?

Hello!

I want to draw random numbers from a Weibull distribution using VBA. I have multiple Weibull distribution with known shape and scale parameter which I want to draw random numbers from. For a normal distribution I used: Worksheetfunction.Round(Worksheetfunction.Norm_Inv(Rnd(), meand,standard deviation,0)
Now I would like something which generates random numbers from a Weibull function with known shape and scale parameter. Only I could not figur out how to do it.

Hope you can help me!
Thanks in advance!

Thom

https://www.vertex42.com/ExcelArticl...domInputs.html