Standard Deviation VBA code

Hey everyone. I need help with the vba code to calculate the standard deviation for any number of values entered into column A. I already have the code for number of values, sum, and average. Having trouble with the standard deviation. Workbook is attached, thanks!

I forgot to mention that I can't use the excel functions in my code. Thanks!