将变量声明为十进制 [英] Declare a variable as Decimal

问题描述

我正在VBA中优化一个宏，该宏没有声明任何数据类型，因此编译器将所有内容都笨拙地视为一个变体.我正在处理科学的测量方法，所以我需要精度.

I'm optimizing a macro in VBA which had none of the data types declared, so everything was clumsily treated by the compiler as a variant. I'm dealing with scientific measurements, so I need precision.

如何声明Dim decAsdf as Decimal(不是那样，而是正确的方式)?

How do I declare Dim decAsdf as Decimal (not like that but the proper way)?

推荐答案

您不能将变量声明为Decimal-您必须使用Variant(可以使用CDec来填充不过).

You can't declare a variable as Decimal - you have to use Variant (you can use CDec to populate it with a Decimal type though).

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