Posted to microsoft.public.excel.programming

Jim Zeeb[_2_] Jim Zeeb[_2_] is offline

external usenet poster

Posts: 23

Preventing Form Dialog dismiss (Red X)

Thanks Jim,

That was just what I was looking for.
:)

"Jim Cone" wrote:

This might be even more useful...

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode < 1 Then
Cancel = True
MsgBox "Please use the cancel button to exit. "
End If
End Sub

Jim Cone

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
dismiss blanks in lookup	Manuel	Excel Worksheet Functions	5	July 30th 07 02:32 AM
Dialog & User Form	bach	New Users to Excel	2	August 13th 05 09:35 PM
How to resize Data Form dialog window?	Compucat	Excel Worksheet Functions	1	June 8th 05 11:24 PM
Dialog Box/Form Help!	Rutgers_Excels[_6_]	Excel Programming	0	October 8th 04 07:01 PM
Trapping and preventing a form from being e-mailed before validation	quartz	Excel Programming	1	April 27th 04 01:50 PM

All times are GMT +1. The time now is 05:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us