Compile Error in VBA Code

[andrewc]

Hi,

I am trying to teach myself how to use VBA and, to that end, I wish to write some code to calculate the standard deviation of a range of data to be selected by the user.

Unfortunately I have stumbled at the first hurdle, receiving a Compile Error when trying to execute the code. Can someone please tell me what is wrong:

Sub Volatility()
    Dim Volatility As Double
    Set Volatility = Application.InputBox("Enter Data Range", Type:=8)
    MsgBox WorksheetFunction.StDev(Volatility)
       
End Sub

Thanks!