Dialog Box Buttons



I generally use standard Yes/No dialog boxes in my worksheets. I have
a need to have a check box at the bottom so users can choose not to
see the dialog box again. I inserted an Excel 5.0 dialog box with a
YES & NO buttons and a check box at the bottom. Does anyone know how I
capture the button the user presses so I can code the macro to
continue or stop? (It is siliar to the task I am trying to accomplish
in the code below if that helps with the explanation.) Thanks for any
help -Michael

Msg = "Compare Cash Value to Balance" & Chr(10) + acct1
Style = vbYesNo
Title = " Cash Verification"
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
Application.Run macro:="chk_units"
End If

Dave Peterson

Didn't you assign a different macro to each button?

If you did, don't you already know which button the user clicked--since you're
running that assigned macro?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question