Declare a variable of the appropriate type (a Long variable) to contain the user's choice : Long « Data Type « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Data Type
3. 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
 

 

Related examples in the same category