How to Override a VBOKCancel button?

V

Venkatesh V

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
 
S

smartin

Venkatesh said:
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
Click to expand...

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
 
J

Jim Cone

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"
<[email protected]>
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
 
Top