VBA中的十进制TryParse [英] Decimal TryParse in VBA

问题描述

我正在尝试使用十进制尝试解析；但是，我不断收到对象必需"的运行时错误.我不确定自己在做什么错.我习惯在C#中进行tryparse.这是VBA，因此语言翻译尚未点击.任何帮助表示赞赏.

 Sub try()
        Dim val As Variant
        Dim res As Boolean

        res = Decimal.TryParse("2.5", val)
        MsgBox (res & ":" & val)
    End Sub

解决方案

您可以尝试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

解决方案

You can try CInt and check for a specific error using On Error Goto.

这篇关于VBA中的十进制TryParse的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！