Re: How to have a user click okay/decline on a form to continue my cod

Tech-Archive recommends: Fix windows errors by optimizing your registry

Fredg,

Southern at Heart needs Accept Decline and some other text on the Command
Button. I didn't think there was a way to get the message box to that, is
there?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"fredg" <fgutkind@xxxxxxxxxxxxxxx> wrote in message
news:k307mlfx32nc.1fwopovpcrzzj.dlg@xxxxxxxxxxxxx
On Tue, 6 Jan 2009 19:24:01 -0800, Southern at Heart wrote:

I am looping through data, and after presenting it to the user, I simply
need
my code to 'wait' for the user to either click acept or decline on the
form,
and then my code will continue...
can this be done?

Code execution will wait for a msgbox to be clicked.
You can have as many MsgBox() functions as you need within your code.

Sub YourCode()
' Do your current code stuff here
If MsgBox("Do you want to accept this?",vbYesNo + vbQuestion) = vbYes
then
' Do the Yes code here
Else
' Do the No code here
End If
' continue with whatever other code you have.
End Sub
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


.

Quantcast