VBA/Excel/Access/Word/Data Type/Long

Declare a variable of the appropriate type (a Long variable) to contain the user"s choice

   <source lang="vb">

Sub dec()

   Dim lngResponse As Long
   lngResponse = MsgBox("Do you want to create the daily report?", _
       vbYesNo + vbQuestion, "Create Daily Report")

End Sub

</source>
   
  

Integer and Long

   <source lang="vb">

Sub longDemo()

   Dim intNumber As Integer
   Dim lngLongNumber As Long
   intNumber = 123
   lngLongNumber = 123456

End Sub

</source>