Question : vba yes no box
Answered by : muddy-moose-eh4m7vbjb1uu
Dim answer As Integer
answer = MsgBox("Text", vbQuestion + vbYesNo + vbDefaultButton2, "Message Box Title")
If answer = vbYes Then MsgBox "Yes"
Else MsgBox "No"
End If
Source : https://www.automateexcel.com/vba/yes-no-message-box/#VBA_YesNo_Message_Box | Last Update : Mon, 28 Jun 21
Question : vba yes no box
Answered by : drab-dog-3p5m63bzvlmj
Sub effacerB2() If MsgBox("Etes-vous certain de vouloir supprimer le contenu de B2 ?", vbYesNo, "Demande de confirmation") = vbYes Then Range("B2").ClearContents MsgBox "Le contenu de B2 a été effacé !" End If
End Sub
Source : | Last Update : Wed, 31 Mar 21