Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In my Outlook 2000 book, in a paragraph describing canceling an
event... "...when an event is cancelled, the event still fires, but the consequences of the event is cancelled. For example, if the user failed to enter data in the required field LastName, the 'Write' event can be used to warn the user and cancel the saving of the edited item, as we see in the code in Listing 4-14. Function Item_Write() if Item.LastName = "" then msgbox "Need to enter last name" Item_write = False end if End Function 'end quote So perhaps some code in the send event (not tested) Function Item_Send If Item_Send = false then Answer = Msgbox "Do you really want to cancel the Save?" If Answer = 1 then Item_send = false else Item_Send = True end if end if End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Outlook - Object Model Guardian | Excel Programming | |||
Send Mail - Code to test whether Lotus Notes / Outlook is used | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming |