Msg boxes
 

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

Msg boxes
 

u shud tip

Dim lResp As Long

lResp = MsgBox("Answer yes or no", vbYesNo)

If lResp = vbYes
'Do something
Else
'Do something else
End If

i hop tht hlps

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Alisha" wrote in message
...
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

Msg boxes
 

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