How possible is to override a VBOKCancel button?

The requirement is to replace it with another dialog containing three
buttons "OK", "Cancel" and "Debug".

OK & Cancel to work the same as in VBOKCancel buttons
for instance: i wanted to add another buttion say "Debug"


Thanks for the reply in Advance
Venkat

Venkatesh V wrote:
How possible is to override a VBOKCancel button?

The requirement is to replace it with another dialog containing three
buttons "OK", "Cancel" and "Debug".

OK & Cancel to work the same as in VBOKCancel buttons
for instance: i wanted to add another buttion say "Debug"


Thanks for the reply in Advance
Venkat

You need to make your own form if you want a button that says "Debug".

Alternatively you could do something like this

Sub Venkatesh_V()
MsgBox "Please click Yes to debug, " & _
"OK to do something else " & _
"or Cancel to do nothing.", vbYesNoCancel
End Sub

Look at Excel vba help under "MsgBox" for your options.
VbYesNoCancel is about as close as you can come.
Another way would be to use a UserForm of your own design.
--
Jim Cone
Portland, Oregon USA



"Venkatesh V"

wrote in message
How possible is to override a VBOKCancel button?
The requirement is to replace it with another dialog containing three
buttons "OK", "Cancel" and "Debug".
OK & Cancel to work the same as in VBOKCancel buttons
for instance: i wanted to add another buttion say "Debug"
Thanks for the reply in Advance
Venkat