I am attempting to tryparse using decimal; however, I keep getting an "Object Required" run-time error. I'm not certain what I'm doing wrong. I'm used to doing a tryparse in C#. This is VBA, so the language translation is not clicking just yet. Any help appreciated.
Sub try()
Dim val As Variant
Dim res As Boolean
res = Decimal.TryParse("2.5", val)
MsgBox (res & ":" & val)
End Sub