pop up box

[Guest]

Hi,
How can I create a pop up box that asks a question and then takes answers in
yes/no?

 

[Bob Phillips]

ans = MsgBox ("Continue (yes) or quit (no)?",vbYesNo)
If ans = vbYes Then
'etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jim Cone]

Look at the MsgBox function in VBA help...

If MsgBox("Did you do it? ", vbQuestion + vbYesNo, "Swati") = vbYes Then
'something
Else
'something else
End If
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"swati" <[email protected]>
wrote in message
Hi,
How can I create a pop up box that asks a question and then takes answers in
yes/no?

 

[Guest]

Probably the quickest is the MsgBox.

Sub popUp()
PopUp = MsgBox("WILL THIS DO THE TRICK?", vbYesNo + vbQuestion, "MY POP-UP")
If PopUp = vbYes Then
MsgBox "That's It"
Else
MsgBox "Not What I wanted"
End If
End Sub