Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel button
When using a custom dialog box why doesn't the cancel button work. I mean yes it takes you out of the dialog box but any values you entered while in it (such as selecting a value from a combo box) are still applied if you hit "Cancel" or "Ok". Is there a way to make the changes not apply if you hit "Cancel"?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel button
What are you telling the Cancel button to do? If you don't have any code in
the event handler then all it will do is close the dialog. Wayne. "IamHaxer" wrote in message ... When using a custom dialog box why doesn't the cancel button work. I mean yes it takes you out of the dialog box but any values you entered while in it (such as selecting a value from a combo box) are still applied if you hit "Cancel" or "Ok". Is there a way to make the changes not apply if you hit "Cancel"? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel button
Sorry, I'm just starting with all of this. I assumed that the cancel button was pre set to actually cancel anything entered. Any ideas on what code I should put in to make it work as an actual cancel button?
"David Battams" wrote: What are you telling the Cancel button to do? If you don't have any code in the event handler then all it will do is close the dialog. Wayne. "IamHaxer" wrote in message ... When using a custom dialog box why doesn't the cancel button work. I mean yes it takes you out of the dialog box but any values you entered while in it (such as selecting a value from a combo box) are still applied if you hit "Cancel" or "Ok". Is there a way to make the changes not apply if you hit "Cancel"? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel button
The answer to your question really depends a lot on what it is you are doing
exactly. If I can give you any general advice in the absence of knowledge about what you are doing then it would be that you could take one of the following approaches. 1. Don't actually make any changes to data until the user clicks OK. Clicking Cancel, therefore, simply avoids committing any changes. 2. Reverse any changes made before the user clicked cancel, when they click cancel. I'd say that 1 is your best bet, especially if you are just getting started. Regards, Wayne. "IamHaxer" wrote in message ... Sorry, I'm just starting with all of this. I assumed that the cancel button was pre set to actually cancel anything entered. Any ideas on what code I should put in to make it work as an actual cancel button? "David Battams" wrote: What are you telling the Cancel button to do? If you don't have any code in the event handler then all it will do is close the dialog. Wayne. "IamHaxer" wrote in message ... When using a custom dialog box why doesn't the cancel button work. I mean yes it takes you out of the dialog box but any values you entered while in it (such as selecting a value from a combo box) are still applied if you hit "Cancel" or "Ok". Is there a way to make the changes not apply if you hit "Cancel"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
message box without ok or cancel button | Excel Discussion (Misc queries) | |||
Inputbox and cancel button | Excel Programming | |||
Cancel Button | Excel Programming | |||
Input Box Cancel Button | Excel Programming | |||
input box cancel button | Excel Programming |