| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Canceling a UserForm
How can I capture the event (if there is one) of a user
clicking the "X" at the upper right of a UserForm? I want my workbook to save when this happens. It's driving me crazy!!! Help!!! Eric W. Madison, WI |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Canceling a UserForm
"Eric W." wrote in message
... How can I capture the event (if there is one) of a user clicking the "X" at the upper right of a UserForm? I want my workbook to save when this happens. It's driving me crazy!!! Help!!! Hi Eric, When the user clicks the X close button on a UserForm the UserForm's QueryClose event is fired. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then ''' User clicked the X close button. End If End Sub -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| canceling simplifying my fractions | New Users to Excel | |||
| Self canceling checkboxes | Excel Discussion (Misc queries) | |||
| canceling of automatic predicative writing | Excel Discussion (Misc queries) | |||
| canceling auto date update | New Users to Excel | |||
| Canceling a Macro that Has Been Scheduled | Excel Programming | |||
Linear Mode
