dialogue response

[erin.sebastian]

Hello everyone,
I have a word document that has a macro attached to it, inside the
macro i open a form and want to send the response (0 or 1) back to my
main module but i don't know how to do this. In vb.net you can say
openDialogue and then set the dialogueResponse which will hand the
response back to your main form.. i don't know how to do it in VBA...
can someone please help?
Thanks,
Erin

 

[Doug Robbins - Word MVP]

See the MsgBox function.

MsgBox Function Example
This example uses the MsgBox function to display a critical-error message in
a dialog box with Yes and No buttons. The No button is specified as the
default response. The value returned by the MsgBox function depends on the
button chosen by the user. This example assumes that DEMO.HLP is a Help file
that contains a topic with a Help context number equal to 1000.

Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Do you want to continue ?" ' Define message.
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "MsgBox Demonstration" ' Define title.
Help = "DEMO.HLP" ' Define Help file.
Ctxt = 1000 ' Define topic
' context.
' Display message.
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then ' User chose Yes.
MyString = "Yes" ' Perform some action.
Else ' User chose No.
MyString = "No" ' Perform some action.
End If

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[erin.sebastian]

So do this instead of using the forms???

 

[erin.sebastian]

I have implemented this code, thanks so much !!!!!!