How to use Decimal data type?

[Sun Tzu]

Excel VBA Editor Help says Decimal is a supported data type, but
defining a variable as Decimal does not work.

Dim decX as Decimal

How can I do this? Is there a reference that I need to add?

Thanks,
Wes

 

[Niek Otten]

Also from VBA Help:

Note At this time the Decimal data type can only be used within a Variant, that is, you cannot declare a variable to be of type
Decimal. You can, however, create a Variant whose subtype is Decimal using the CDec function.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Excel VBA Editor Help says Decimal is a supported data type, but
| defining a variable as Decimal does not work.
|
| Dim decX as Decimal
|
| How can I do this? Is there a reference that I need to add?
|
| Thanks,
| Wes
|

 

[Dave Peterson]

I'd use:

Dim decX as variant
decx = cdec(someothervariable)

 

[Guest]

Hi,

Use 'Single' for 7 decimals of precision or 'Double' for 15 decimals of
precision

Mike.

 

[Sun Tzu]

I see now.
Thanks much!
Wes

 

[Sun Tzu]

Hi, Mike,

Unfortunately, not all decimal values convert accurately to binary
formats. That's why Decimal format exists.

Thanks,
Wes

 

[Sun Tzu]

Thanks, Dave!
Wes

I'd use:

Dim decX as variant
decx = cdec(someothervariable)