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

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

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

Integer and Long

 
Sub longDemo()
    Dim intNumber As Integer
    Dim lngLongNumber As Long
    intNumber = 123
    lngLongNumber = 123456
End Sub