| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"ByVal Cancel As MSForms.ReturnBoolean"
AHA INSIGHT. Thank you very much, Rob and Tom.
"Rob Bovey" wrote: MSForms.ReturnBoolean is a class exposed by the MSForms type library. This class has only one property, the default Value property. The purpose of an MSForms.ReturnBoolean variable is not to pass any information into an event it's to allow you to pass information back to VBA telling it whether or not you want to cancel the current operation. Setting the Cancel = True (the equivalent of Cancel.Value = True) means you do want to cancel the operation. Setting Cancel = False or leaving it with its default value of False means you don't want to cancel the operation. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "rbyteme" wrote in message ... Have been unable to find any help on these details, nor any VB programmers who can give a definitive answer... the subject line code is default for many event subs in VBA. exactly what is setting the Cancel var?? to put it another way, when or what would cause the var Cancel to be True? Have tested in a huge # of scenarios involving closing and cancelling forms and controls, and have yet to see Cancel = anything besides False. also...ReturnBoolean is obviously not same as Boolean. can it be anything else besides True or False? would it be useful anywhere else? thanks for any replies :) |
| 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 Worksheet Functions | |||
| how to stop program with loop by click "Cancel" button | Excel Programming | |||
| Close workbook with "Cancel=TRUE" in the BeforeClose()" | Excel Programming | |||
| Call Sub Procedure object_Exit(ByVal Cancel As MSForms.ReturnBoole | Excel Programming | |||
| MSForms cancel | Excel Programming | |||
Threaded Mode
