how to send a response "YES" for a message BOX

[jmgs98]

how to send a response "YES" for a message BOX using VB commands and do not have to manually input the yes while running the program?

Thanks,

 

[cLFlaVA]

I'm not sure I understand your question, but here is an answer:

Clicking on the Yes button in a Yes/No messagebox will return the value of vbYes.

So, you could do the following:

Dim response as Integer
response = MsgBox ("Are you sure?", vbYesNo)
if response = vbYes Then
    'do stuff if user says yes
Else
    'do stuff if user says no
End If

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[zemp]

or,

If MsgBox ("Are you sure?", vbYesNo) = vbYes Then
    'do stuff if user says yes
Else
    'do stuff if user says no
End If

zemp

 

[cLFlaVA]

Touché.

However, this may get slightly messier with, say, a vbYesNoCancel Messagebox, where you may want to do something for different button events.

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[zemp]

Yes, with vbYesNoCancel (three choices) I like to use a response integer and a Select Case structure.

zemp

 

[CasperTFG]

It has a better explanation of his real question.

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".