-
i don't know how to get the return value frm msgbox, can u guys help me?
here is my code:
sDate1 = InputBox("What is the START date?(dd/mm/yy)")
sDate2 = InputBox("What is the END date?(dd/mm/yy)")
MsgBox "Date from" & " " & sDate1 & " to" & " " & sDate2 & ". Correct?", vbOKCancel + vbQuestion, "Weekly / Monthly Report"
How i know wether the user is click on OK or Cancel??
thanks.
-
Msgbox is a function too...
Code:
ret = MsgBox("Date from" & " " & sDate1 & " to" & " " & sDate2 & ". Correct?", vbOKCancel + vbQuestion, "Weekly / Monthly Report")
Select Case ret
Case vbYes
Case vbOK
Case vbCancel
End Select