variable answer will hold the value 32 after execution of this block, not 31.8 as you might want. : Data Type « Data Type « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Data Type » Data Type 
variable answer will hold the value 32 after execution of this block, not 31.8 as you might want.
 
Sub IntegerType()
    Dim answer As Integer
    Dim num1 As Single
    Dim num2 As Integer
    num1 = 5.3
    num2 = 6
    answer = num1 * num2
    Debug.Print answer
End Sub

 
Related examples in the same category
1.Common Data Types
2.Constants are declared using the Const keyword
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.