VBA/Excel/Access/Word/Language Basics/Variable Type

Define an integer

   <source lang="vb">

Sub intSub()

  Dim number As Integer
  number = 32

End Sub

</source>
   
  

Define a string variable

   <source lang="vb">

Sub stringSub()

   Dim lastName As String
   lastName = "Smith"

End Sub

</source>
   
  

Mix integer and string in MsgBox

   <source lang="vb">

Sub msgBox()

  "Declare the variables
  Dim intNumber1 As Integer
  Dim intNumber2 As Integer
  Dim intSum As Integer
  "Create InputBoxes to enter numbers
  intNumber1 = 1
  intNumber2 = 2
  "Add numbers
  intSum = intNumber1 + intNumber
  Debug.Print "The numbers entered were " & intNumber1 & " and " & intNumber2

End Sub

</source>
   
  

Read integer number from InputBox

   <source lang="vb">

Sub addNumbers()

  "Declare the variables
  Dim intNumber1 As Integer
  Dim intNumber2 As Integer
  Dim intSum As Integer
  "Create InputBoxes to enter numbers
  intNumber1 = 1
  intNumber2 = 2
  
  Debug.Print intNumber1 + intNumber

End Sub

</source>
   
  

Types of Variables

   <source lang="vb">

Variable Type Description Boolean True or False. Byte It can only hold a single value between 0 and 255. Currency It holds a currency value with four decimal places, from -922,337,203,685,477.5808 to 922,337,203,685,477.5807. Date This stores both dates and time. Interestingly, the years range from 100 to 9999. Double Doubles are for very large numbers. The range runs from -4.940656458411247 * 10^-324 to 4.94065645841247 * 10^-324. Integer nteger handles the range of numbers -32,768 to 32,767. Long Long handles the number range -2,147,483,648 to 2,147,483,657. Object You can store an object as a variable for later use. Single This is the second decimal point type, the other being Double. String A String variable can hold up to 2 billion characters.

</source>