The Currency data type allows for positive and negative numbers with up to 15 digits to the left of the decimal point and 4 digits to the right of it : Currency Type « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. Currency Type

The Currency data type allows for positive and negative numbers with up to 15 digits to the left of the decimal point and 4 digits to the right of it

 
Sub Calculate_Weekly_Salary()
    Salary@ = InputBox("Enter your salary.", "Calculate Weekly Salary")
    WeeklySalary@ = Salary / 52
    MsgBox WeeklySalary
End Sub








Related examples in the same category

1.Currency