Book1.xlsm

Attached is an example of what I need. I have a userform that when opened has two text boxes, one for the average of the data, and one for the number of random values.

So I need to generate a random data set in column A. I need the number of random values to be equal to the number pasted into cell C4. I need the average to be value in cell C5. The standard deviation needs to be the value in cell H7.

Essentially what I need to do is have a macro that I can attach to the button that closes the userform that would clear the contents in Column A, then generate a set of random number based on the average in cell C5 and the standard deviation in cell H7. I need the number of random values to be equal to the value in cell C4, so the original is 10 random values, but if I put in 100 for cell C4, I want 100 random values.

Can anybody help me with the VBA for this??? Take a look at what I have as I think I am close but for some reason it doesn't quite work with the VBA line ".Range("A2").Resize (Me.TextBox1.Value)".

Any help is appreciated.