msgbox vbyesno

Hi

I am struggling to work out how to get the vbyesno statements from a msgbox to work for my user defined function below.
the statements are

MsgBox "You have selected to use " & N & " days" & " of data" _
& " and you have selected a price range of:" & PriceRange.Address(external:=True) & "," & " is this OK?", vbYesNo
If MsgResult = vbNo Then End

and

msgBox "Would you like to use the annualised volatility to calculate the sharpe ratio of the selected range?", vbYesNo
If MsgResult = vbNo Then Exit Function


However both the do not work as the function keeps running. Please how can i get them to work and end the procedure once no is clicked? coding below.

Thanks

Please Login or Register  to view this content.

Msgbox is a function; it returns a value:

Please Login or Register  to view this content.