Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"cancel" caption doesn't show up on cancel dialog
My cancel button macro works.
When I click "cancel" on my form it gives the normal cancel dialog but it just has an okay button on it, no words saying "cancel". There is no other option, when you push cancel it cancels but it gives the dialog box and lets you push the okay button. I think that is fine but it should say "cancel". I looked on the properties window: cancel = true default = true enabled = true take focus on click = true tab stop = true also the caption is "Cancel" I tried this on the cancel macro. Public Sub cmdCancel_Click() Unload Me vbCancel End Sub do you know how to make it say "cancel"? thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"cancel" caption doesn't show up on cancel dialog
Not just 100% sure what you want. Do you want to show a message box to the
user and give them the opprotunity to really cancel or not... If MsgBox("Are you sure you want to cancel?", _ vbYesNo + vbQuestion, _ "Cancel") = vbYes Then Unload Me -- HTH... Jim Thomlinson "Janis" wrote: My cancel button macro works. When I click "cancel" on my form it gives the normal cancel dialog but it just has an okay button on it, no words saying "cancel". There is no other option, when you push cancel it cancels but it gives the dialog box and lets you push the okay button. I think that is fine but it should say "cancel". I looked on the properties window: cancel = true default = true enabled = true take focus on click = true tab stop = true also the caption is "Cancel" I tried this on the cancel macro. Public Sub cmdCancel_Click() Unload Me vbCancel End Sub do you know how to make it say "cancel"? thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"cancel" caption doesn't show up on cancel dialog
Maybe you are right since they already choose cancel. it just looks weird,
it is a dialog box with no words on it except the okay button and with it saying nothing it looks like there is nothing to do. I tried it your way and it looks better. "Jim Thomlinson" wrote: Not just 100% sure what you want. Do you want to show a message box to the user and give them the opprotunity to really cancel or not... If MsgBox("Are you sure you want to cancel?", _ vbYesNo + vbQuestion, _ "Cancel") = vbYes Then Unload Me -- HTH... Jim Thomlinson "Janis" wrote: My cancel button macro works. When I click "cancel" on my form it gives the normal cancel dialog but it just has an okay button on it, no words saying "cancel". There is no other option, when you push cancel it cancels but it gives the dialog box and lets you push the okay button. I think that is fine but it should say "cancel". I looked on the properties window: cancel = true default = true enabled = true take focus on click = true tab stop = true also the caption is "Cancel" I tried this on the cancel macro. Public Sub cmdCancel_Click() Unload Me vbCancel End Sub do you know how to make it say "cancel"? thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet | Excel Discussion (Misc queries) | |||
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet | Excel Worksheet Functions | |||
Stop code from running when I click "Cancel" | Excel Programming | |||
how to stop program with loop by click "Cancel" button | Excel Programming | |||
Close workbook with "Cancel=TRUE" in the BeforeClose()" | Excel Programming |