The currency data type provides a way to store data accurately. Other decimal numerical datatypes are prone to rounding errors.
Below is an example of declaring, assigning and utilizing a currency number.
Code Snippet :
Sub a4_6_Currency()
Dim x As Currency
x = 10.34
MsgBox x
End Sub
VBA and Microsoft Excel - Getting the most out of excel with VBA programming
VBA and Microsoft Word - Getting the most out of word with VBA programming
Application Object - Using the applications features in your code.
Installing VBA and First Program - What do you need to start using visual basic application VBA.
Related Sections
Python - Learn the python from the basics up. This fast track example code course will get you creating powerful python programs in no time.Must Read Articles
VBA and Microsoft Excel - Getting the most out of excel with VBA programming
VBA and Microsoft Word - Getting the most out of word with VBA programming
Application Object - Using the applications features in your code.
Installing VBA and First Program - What do you need to start using visual basic application VBA.