Hi Alisha,

Sub test()
Dim l As Long

l = MsgBox(Prompt:="Please click yes or no", _
Buttons:=vbQuestion Or vbYesNo Or vbDefaultButton1, _
Title:="Question")

If l = vbYes Then
MsgBox "You clicked yes"
Else
MsgBox "You clicked no"
End If
End Sub

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Alisha wrote:
sori im not very good with computers,

can u pls tell me exactly wat needs to by typed.i kno
where 2 type it.
i want a message box saying yes or no